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?
Click to expand...

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

Similar Threads

automatic Conversion from A97 to A2K 1
A2K-TOOLS - Convert Database to current ACCESS-Version 2
batch print some specific pages in multiple word files 1
To make pdf to work as word 1
batch extract all tables from multiple word documents 1
Tasks for converting A97 to A2K 2
Weird Report Issue - A2K File Run W/A2K2 or Higher 0
Reduce image size 0

Top