N/APosted on - 03/11/2012
I really wonder about this, because Visual Basic 6.0 was released before Microsoft Access 2000 and I used Microsoft 2007 and 2000. When i try to connect it, I'll get a message saying that "invalid database format". Does somebody has an idea about this?
What format and version of Microsoft Access to connect Visual Basic 6.0?
Hey Fallout 213!
The problem you are facing is just a compatibility issue the Data Object Access only accepts data from MS Access 2000.
But if you want to use it with MS Access 2007 it will give you the same error.
Now there are three options for you.
1. First option is to convert your Data Base to another version (previous version).
2. Secondly, you can connect your Data Base in jet place by using Open Data Base Connectivity (ODBC).
3. Third and last option is: Do not use Active Data Object (ADO). you can use Active Data Object Data Control (ADODC)
One more thing XP Database can be connected by Active Data Object (ADO), if your version of Microsoft Data Access Component (MDAC) is newer.
I will suggest you the first option.