How to use Access 2000 with VB 6? ERROR "Unrecognized database format"

[sergeiY]

Hi,

I am trying to connect Ms Access 2000 DB to my VB6.0 project but I am getting error "Unrecognized database format" I've tried to connect to some Access DBs that come with VB (I gouess they're earlier version of Access) and I can connect no problems.

Is there a way to connect to a newer version of Access ?

Thank you.

 

[AkutaSame]

It is possible that you aren't using the correct Jet engine (make sure you are using 4.0), and make sure you are using ADO (which will allow for the Jet 4.0 Engine).

 

[sergeiY]

AkutaSame,

How do I do that ? I am new to VB ... I just started a new project droped couple of objects on the form and tried to connect them to DB...

 

[DrJavaJoe]

Do you have Service Pack 5 for VB installed, if not here's a link

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/default.asp

.

 

[AkutaSame]

Good idea JavaJoe.

Sergei,
When you draw the ADO control onto the form, you right click it and go to properties. It will give you the option to choose which engine the control will use. Make sure that SP5 is installed before you do this, as it will prevent any issues you may come across due to the limitations of DAO data access with an Access 2k database. DAO, in my opinion, is now a waste of time with ActiveX controls that can do more (ADO).

 

[sjn78]

Hi,

I have had the same problems as sergeiY. I have SP5 installed and just about every other update under the sun.

I use a 2000 db and connect with Jet 4.0

When making the ado connection through its properties, you can click test connection and all is good. But once you try to use the ado control with a text box or whatever you use, it brings up that error.

I spent too many days trying to figure out what was wrong....I gave up.

 

[DrJavaJoe]

sjn78, the problem may be that your database is corrupt. Goto access and open each table and query and see if it generates the same error. If it does make a backup and run the Compact and Repair under Tools -> Database Utilities. You may have to reestablish some relationships afterward.

 

[sergeiY]

I have run the update and it works now no problems.

Thanks a lot to everybody.