Hello Everyone!
I am trying to connect to an Access 7.0 Database using VB 6 and ADO. I am really bad/rusty with this stuff!
Anyway, when I run it from my development computer either from within VB or as the installed application, it is fine. When I install it elsewhere, I get the following error:
Runtime error 3706
Provider cannot be found. It may not be properly installed.
In my application, this is how I named the provider:
cnnAccess.Provider = "Microsoft.Jet.OLEDB.3.51"
cnnAccess.Open "S:\Test Database\Test Data.mdb"
The computer I installed the application onto has that S: drive mapped and can see the database file.
In my project References, I have included the ADO 2.5 Library, and also the DAO 3.51 Object Library.
Any suggestions on what I am doing wrong? How can I make sure that the correct Provider is installed on the target computer?
Thanks!
I am trying to connect to an Access 7.0 Database using VB 6 and ADO. I am really bad/rusty with this stuff!
Anyway, when I run it from my development computer either from within VB or as the installed application, it is fine. When I install it elsewhere, I get the following error:
Runtime error 3706
Provider cannot be found. It may not be properly installed.
In my application, this is how I named the provider:
cnnAccess.Provider = "Microsoft.Jet.OLEDB.3.51"
cnnAccess.Open "S:\Test Database\Test Data.mdb"
The computer I installed the application onto has that S: drive mapped and can see the database file.
In my project References, I have included the ADO 2.5 Library, and also the DAO 3.51 Object Library.
Any suggestions on what I am doing wrong? How can I make sure that the correct Provider is installed on the target computer?
Thanks!