Use Of Microsoft Access accdb ODBC Driver
In this i will explain you about how to use MS-ACCESS ODBC Driver
Introduction
This is a ODBC Driver provided by Microsoft.
Coding
|
Include "Driver={Microsoft Access Driver (*.mdb, *.accdb}" in the connection string to use this driver.
|
Code For Security
|
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\mydatabase.accdb;Uid=Admin;Pwd=;
|
With database
|
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\mydatabase.accdb;SystemDB=D:\mydatabase.mdw;
|
Exclusive code
|
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\mydatabase.accdb;Exclusive=1;Uid=admin;Pwd=;
|
Code for Enable admin statements
|
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\mydatabase.accdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;
|
Code for Specifying locale identifier
|
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\mydatabase.accdb;Locale Identifier=2057;Uid=Admin;Pwd=;
|
You may also want to read these related articles :here
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answer here