I'm trying to create a VB program to hit an Access 2000 database but whenever I try to select a recordset, I get an "invalid format" for the database file!! Is there a patch out there so that VB 6 can read Access 2K? Need help fast....
-Ozman
Printable View
I'm trying to create a VB program to hit an Access 2000 database but whenever I try to select a recordset, I get an "invalid format" for the database file!! Is there a patch out there so that VB 6 can read Access 2K? Need help fast....
-Ozman
How are you connecting to Access?
If you are using code, than you have to set reference to Microsoft DAO 3.6 Object Lybrary.
Or you can use Microsoft ADO Data Control 6.0
Before using patches, changing to DAO, etc. You might just need to check your connection string. I think you need to change Jet 3.51 to 4.0 when connecting to Access 2000. This worked for me. ( I am assuming you are using ADO 2.0 or 2.1, if not, try the others.)
-Elias
[Edited by Elias on 04-25-2000 at 11:21 PM]