ODBC data source for MS access as back end and vb as front end.
Installation Process
go to control panel -> administrative tools --> select data sources(ODBC) --> then right click on that file --> go to properties -->
in the shortcut tab ->
set the path "%windir%\SysWOW64\odbcad32.exe" and make your connexion the driver for Ms Access will work fine now
|
Security code
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Uid=Admin;Pwd=;
|
use of workgroup
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;SystemDB=C:\mydatabase.mdw;
|
Exclusive code
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Exclusive=1;Uid=admin;Pwd=;
|
Code for Enable Admin
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;
|
Specifying locale identifier
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Locale Identifier=2057;Uid=Admin;Pwd=;
|
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here