VB connection to Access

[eko976]

Hi
I can not connect VB to Access.
I have VB 6.0 ENterprise and Access Xp with default at 2000 format.
I am trying to connect with ADo using Jet engine
Each time I try to connect it says "Database not recognized"
If I convert to Access 97 it works
In the property window I choose "Connect" then I go to Access
What is interesting it doesn't show Access 2000 and in my school the option for 2000 is possible
That is probably the problem but I don't know how to solve it

[eko976]

Anybody knows?

[kingsucka]

Since no one else with more credentials is replying, I take a stab at it. Try this

Create a file of type text with Notepad and save it with the extension .udl
Double clicking on this file brings up the connection wizard. Click on the Provider Tab and select Microsoft Jet 4.0 OL DB Provider.
Click on the Connection Tab and select the ellipse and browse to select your Microsoft Access Database. .
Test the Connection. If the Ok screen appears, your connection string is setup properly.
Close the Wizard.
Go into MyComputer and drag the file you just created into an instance of Notepad.
Open Notepad, you will see the connection string..

This is how I check to see if my stuff is correct. I mostly use ASP.NET (vb) in web applications, so I am definately not an authority on this. I hope it helps.