Programmatic Database Conversion

[Guest]

Dear sirs: I have read and searched for help but come up with
nothing...hence this simple question. Is it possible to convert an Access 97
..mdb to Access 2002-2003 .mdb programmatically using VBA? I know I can
convert using the Access 2003 menu Tools --> Database Utilities --> Convert
Database, but I need to be able to convert Access 97 mdb's programmitically.
I read about Syscmd 605, but that converts in the wrong direction. Any help
would be greatly appreciated.

MikeBromley

 

[Guest]

Sorry, finally found my own answer. I used Method ConvertAccessProject.
Works fast, too! Is there something I can test to know what Access file
format a .mdb is before it's open? Still need help, but I'm looking...

MikeBromley

 

[Guest]

Finally, got my own answer. Found Property FileFormat. Hope this helps
anyone else.

MikeBromley