VB 6.0 and Access 2000

[chris6user]

I run vb6 + sp5 + mdac 2.7. When I try to connect application to Access 2000 it gives me an error message what the database is a wrong format. Is there still a problem with VB6 and Access 2000?

 

[KyleS]

How are you connecting to the Database?

I don't have VB in front of me but in order to connect to the DB you need to use the Jet 4.0 Otherwise you'll get that error..

Kyle Kyle :

 

[chris6user]

I am trying to open Access db with Visual Data Manager or just use data control.

 

[jasek78]

Check out this FAQ I just wrote to get the Access 2000 databases to work with the VisData Manager Addin...

faq709-1590


jason

 

[Jaked]

Instead of using a DAO use an ADODC. It is found under components.

Create a control on the form and in your property box go to custom.

Then at "Use connection string" click on build.
On the provider tab select Jet 4.0 click on next
Select your database name and click on test connection
click on ok

Back to Property page:
Select recordsource
At the Command type dropdown list select "2-adCmdTable"
Under table or stored procedure name select the table name.

I hope this helped
God bless