Sunday, 27 May 2012
How to connect MS Access database to odbc in Win 7 x64 bit?
How to connect MS Access database to odbc in Win 7 x64 bit?
After you finish creating database in MS Access follow the steps as given:
· Go to start menu
· Select Computer and click on c drive.
· Click on Windows folder in c derive
· Then Click on SysWOW64.
· Check for odbcad32 and click on it.
· After that click on System DSN from popup box.
· Click on add option
· A dialog box will open called create New Data Source from that select .mdb option and click on it.
· One new dialog box will open
i) Enter your Data Source Name ,you can give different or same name to your DSN
(1) For eg if database name is lab.mdb
(2) You can save your DSN as lab or labmaster
(3) NOTICE:lab and Lab makes a difference in DSN so be carrefull while specifying your DSN.
ii) ----Database—
iii) Click on the select button , a select dialog box will open .
iv) In the select dialog box select your database name just by changing the drive from the drive column .
v) Then Click Ok.
· After that Click OK until all dialog box is closed.
After you finish creating database in MS Access follow the steps as given:
· Go to start menu
· Select Computer and click on c drive.
· Click on Windows folder in c derive
· Then Click on SysWOW64.
· Check for odbcad32 and click on it.
· After that click on System DSN from popup box.
· Click on add option
· A dialog box will open called create New Data Source from that select .mdb option and click on it.
· One new dialog box will open
i) Enter your Data Source Name ,you can give different or same name to your DSN
(1) For eg if database name is lab.mdb
(2) You can save your DSN as lab or labmaster
(3) NOTICE:lab and Lab makes a difference in DSN so be carrefull while specifying your DSN.
ii) ----Database—
iii) Click on the select button , a select dialog box will open .
iv) In the select dialog box select your database name just by changing the drive from the drive column .
v) Then Click Ok.
· After that Click OK until all dialog box is closed.
Subscribe to:
Posts (Atom)