Use Of Microsoft Access accdb ODBC Driver

In this i will explain you about how to use MS-ACCESS ODBC Driver
  • 2588

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

Categories

More Articles

© 2013 dotNetheaven. All rights reserved.