A97 to A2k Conversion by batch or VBA


H

harmi

Hi
i have several A97-mdbs to convert to A2K.
Is there a way to automate this with a batch-file or via VBA?
Thanks for your inputs
 
T

Tony Toews [MVP]

harmi said:
i have several A97-mdbs to convert to A2K.
Is there a way to automate this with a batch-file or via VBA?
If you only have several then it should be no big deal to do it
manually. That said you can use


DBEngine.CompactDatabase "olddb", "newdb", , dbVersion40

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top