Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

Connecting To mdb from Windows 7 PC

I've been battling this problem for almost a month.

I have a VB 2010 application that connects to an Access 2003 Database on the server. I have tried to change the connection string from "4.0" to "12.0" - following EE suggestions, but now I just get the same error "Not Registered on This Machine" only referencing OLEDB.12.0 instead of OLEDB.4.0.

I have found some suggestions on other sites recommending that I download either "AccessDatabaseEngine.exe" or "AccessDatabaseEngine_64.exe" but I want to be sure that what I am doing is configuring the one Windows 7 machine to talk to the 32 bit Access 2003 mdb file, and NOT stepping on the mdb - which is also addressed by numerous users still on Windows XP boxes.

Any step by step assistance would be appreciated.
0
Buck_Beasom
Asked:
Buck_Beasom
  • 3
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
are you on Windows 64-bits? the easy answer is to target the x86 platform in your project
0
 
Éric MoreauSenior .Net ConsultantCommented:
0
 
Buck_BeasomDatabase DesignerAuthor Commented:
emoreau

I went to the site you provided and found both drivers - which I had already downloaded earlier.

I just don't know what to do with them. Do I run the AccessDatabaseEngine_64.exe on the Windows 7 client? Will the provider string then be "12.0" or "14.0"? I have seen both suggested.

Thanks. (And for help you have provided me in the past!)
0
 
Éric MoreauSenior .Net ConsultantCommented:
yes you need to install the engine. because it is the 2010 version, you need to use 14.0
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now