A97 to A2k Conversion by batch or VBA

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

  1. harmi

    harmi Guest

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