A97 to A2k Conversion by batch or VBA

Discussion in 'Access Conversion' started by harmi, Feb 22, 2010.

  1. harmi

    harmi Guest

    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
    harmi, Feb 22, 2010
    1. Advertisements

  2. 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 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/
    Tony Toews [MVP], Feb 23, 2010
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.