Use of ODBC Driver in MS-ACCESS

In this Article we are study about ODBC Driver in MS-ACCESS
  • 2560

Introduction

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.