Hi,
I have a scenario where I need to open a table in MS Access 2000 using AD0.  But when I try to open it up, it says it's an unrecognized database, or an unrecognized format.  Does anyone know why that might be?
Below is how I'm opening the file.  

I've also been unable to solve the problem of creating a new database right from VB using ADO.  Can anyone please offer some insight on that?


connectString = "Provider=Microsoft.Jet.OLEDB.3.51;"  & "Data Source=filestructure04.mdb"
adoConnection.Open connectString
adoRecordset.Open "struct04", adoConnection

Thanks

Not completely certain, but it may need to be:

Microsoft.Jet.OLEDB.4.0

Although if you add a ADODC1 control on a form, use the connection string building function to create the string (using the newest/highest numbered Jet), and test to see if you can connect.

Although the DB may need repairing.

hi

In access 2000 use Provider=Microsoft.Jet.OLEDB.4.0
otherwise your code is ok

Thanks guys...it worked.  

use provider 4.0