What format and version of Microsoft Access to connect Visual Basic 6.0?

Asked By 20 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 10 points N/A #127297

What format and version of Microsoft Access to connect Visual Basic 6.0?

qa-featured

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.

Thanks

 

Login/Register to Answer

Related Questions