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='Micr osoft.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
programmaticall y. Any help is appreciated. Thank you.

[lyle fairfield]

Re: Use Catalog.Create to make an earlier version .mdb

Tim Dunne <timmydunne@gma il.comwrote in news:44a34d96-fb96-4243-aeea-
6df817180e5a@a7 0g2000hsh.googl egroups.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='Micr osoft.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
programmaticall y. 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.Applicat ion
Set a = New Access.Applicat ion
With a
.NewCurrentData base "new.mdb", acNewDatabaseFo rmatAccess2000
.Quit
End With

[Tim Dunne]

Re: Use Catalog.Create to make an earlier version .mdb

that did the trick -- thank you!