Creating an Access MDB from within VB

[peet]

Originally posted by MrGTI
I tried yours peet, and when i try to open the newly created .MDB file in Access i get an error - Unrecognized database format

Any ideas why? I have Access 97, but that shouldn't be a problem.

this line

cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\newDB.mdb"

generates an Access2000 db, not possible to open in Acc97 I think. (Microsoft.Jet.OLEDB.4.0 = acc2k)

not sure if this will work, but try

cat.Create "Provider=Microsoft.Jet.OLEDB.3.5;Data Source=c:\newDB.mdb"

(Microsoft.Jet.OLEDB.3.5 = acc97 well I hope )