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

Asked By fallout213 20 points N/A Posted 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?

• Status: Open
• Question Views: 807
• Answer Count: 1
• Vote Up 2 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Tunacao_Caaron1 20 points N/A #127297

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.

Thanks

 

About Tunacao_Caaron1

Questions
1

Answers
399

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 03/11/2012
• Question Category: Visual basic