Use Catalog.Create to make an earlier version .mdb

[Tim Dunne]

I created an application in Access 2007. One of the features required
by the client is to create an .mdb file with one table in it for their
use (strange yes -- I provided alternate solutions, but their IT guy
insists). I use adox and the following line of code to do this:

cat.Create "Provider='Microsoft.Jet.OLEDB.4.0';" & _
"Data Source='" & strPath & "'"

It works fine, but defaults to an access 2002-2003 format. I need the
database to be formatted for access 2000. I am currently going in and
manually changning it, but I wonder if there is a way to do this
programmatically. Any help is appreciated. Thank you.

[lyle fairfield]

Tim Dunne <ti********@gmail.comwrote in news:44a34d96-fb96-4243-aeea-
6d**********@a70g2000hsh.googlegroups.com:

I created an application in Access 2007. One of the features required
by the client is to create an .mdb file with one table in it for their
use (strange yes -- I provided alternate solutions, but their IT guy
insists). I use adox and the following line of code to do this:

cat.Create "Provider='Microsoft.Jet.OLEDB.4.0';" & _
"Data Source='" & strPath & "'"

It works fine, but defaults to an access 2002-2003 format. I need the
database to be formatted for access 2000. I am currently going in and
manually changning it, but I wonder if there is a way to do this
programmatically. Any help is appreciated. Thank you.

TTBOMK ADOX is 100% redundant, that is there is nothing it can do that
other technologies cannot do faster, simpler.

I !!!!think!!!! that you can accomplish what I !!!!think!!!! you want to
accomplish with:

Dim a As Access.Application
Set a = New Access.Application
With a
.NewCurrentDatabase "new.mdb", acNewDatabaseFormatAccess2000
.Quit
End With

[Tim Dunne]

that did the trick -- thank you!