Discussion:
A97 to A2k Conversion by batch or VBA
(too old to reply)
harmi
2010-02-22 09:07:14 UTC
Permalink
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
Tony Toews [MVP]
2010-02-23 02:23:09 UTC
Permalink
Post by harmi
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/
Loading...