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.

Tim Dunne <timmydunne [at] gmail.com> wrote in news:44a34d96-fb96-4243-aeea-
6df817180e5a [at] 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

that did the trick -- thank you!