The menu for today's interface is initially determined.
Next, the first is the database design, in the end to use what database good? With SQL Server? Too big, do not want to pretend, with MySQL, no use, no download, with Oracl, too formal, not to use. Finally I would like to use Access bar, installed locally. However, when the connection occurs: "Not registered on the local computer" Microsoft. jet.oledb.12.0 "Provider", this is because of the version of the problem, my environment is vs2012+access2013, workaround:
The first step, download the installation of Microsoft Access Database Engine, a total of 32bit and 64bit two versions, specifically to install which depends on whether your program is 32bit or 64bit, rather than the version of the PC;
32bit:http://download.microsoft.com/download/2/4/3/24375141-e08d-4803-ab0e-10f2e3a07aaa/accessdatabaseengine.exe
64bit:http://download.microsoft.com/download/2/4/3/24375141-e08d-4803-ab0e-10f2e3a07aaa/accessdatabaseengine_x64.exe
The second step is to modify the provide microsoft.ace.oledb.12.0 of the database connection string (formerly provide microsoft.jet.oledb.4.0).
Next, the attempt to connect is correct.
?
Attached: Access connection string
Standard links :
"Driver= {Microsoft Access Driver (*.mdb)};D bq=c:\app1\ your database name. mdb; uid= your user name; pwd= your password;
If the Access database does not have a user name and password set, leave it blank. Same below
Workgroup mode (workgroup mode) connection :
"Driver={microsoft Access Driver (*.mdb)}; Dbq=c:\app1\ your database name. mdb; Systemdb=c:\app1\ your database name. mdw; "
Connect in an exclusive way :
"Driver={microsoft Access Driver (*.mdb)}; Dbq=c:\app1\ your database name. mdb; exclusive=1; uid= your user name; pwd= your password;
MS ACCESS OLE DB & OleDbConnection (OLE DB interface under. NET) links
normal way (most commonly used) to connect to an Access database :
"Provider=Microsoft.Jet.OLEDB.4.0; Data source=c:\app1\ your database name. mdb; User id=admin; Password= "
To connect to an Access database by using workgroup mode (System database) :
"Provider=Microsoft.Jet.OLEDB.4.0; Data source=c:\app1\ your database name. mdb; Jet oledb:system database=c:\app1\ your system database name. MDW "
connect to an Access database with a password :
"Provider=Microsoft.Jet.OLEDB.4.0; Data source=c:\app1\ your database name. mdb; Jet oledb:database password= Your password "
connect to an Access database on a LAN host :
"Provider=Microsoft.Jet.OLEDB.4.0; Data source=\\server_name\share_name\share_path\ your database name. mdb "
connect to an Access database that is on a remote server :
"Provider=ms Remote; remote server=http://server IP; Remote provider=microsoft.jet.oledb.4.0; Data source=c:\app1\ your database name. mdb "
Microsoft is not registered on the local computer. ace.oledb.12.0 "Provider