Creating Access 97 DB using ADOX

I'm trying to get my application to create a new Access DB using ADOX. It seems to be creating the file, but whenever I try to access it manually it gives me the error message 'Unrecognized Database Form 'D:\NewDB.mdb'.

Set cat = new Adox.catalog

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

and then try to create some tables, it gives the same error message wether I try to create tables or not.

Anybody got any ideas about what I'm doing wrong.

Cheers.

Bit of a guess, but try using Jet 3.51 instead of 4?

yep that works, cheers Pete

You can use 4.0, if you type Enginetype to 4.
Type 5 is Access 2000 format

VB Code:

cat.Create "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\MyDatabase.mdb"  _
        & ";Jet OLEDB:Engine Type=4"