Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


I need the vba code ran in Access 2003 to convert a 97 database to Access 2000

Posted on 2005-03-09
Medium Priority
Last Modified: 2008-03-17
Please, please, please can someone give me the VBA code to convert "database1.mdb", a Microsoft Access 97 file into "database2.mdb"

Thank you, thank you, and thank you.
Question by:stephenlecomptejr
  • 2
  • 2
LVL 66

Accepted Solution

Jim Horn earned 2000 total points
ID: 13502092
Hi stephenlecomptejr,

I haven't tried this before, but the below VBA command seems to do the job for you...
Application.ConvertAccessProject "Old.mdb", "new.mdb", acFileFormatAccess2000

Hope this helps.
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 13502222
you can try this

Public Sub ConvertDB()

   CommandBars("Menu Bar"). _
   Controls("Tools"). _
   Controls("Database utilities"). _
   Controls("Convert Database"). _
   Controls("To Access 2000 File Format..."). _

End Sub

LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 13502296
sorry forget what i posted...
LVL 54

Expert Comment

ID: 13505749
Hmm, a warning might be inplace, check:

LVL 66

Expert Comment

by:Jim Horn
ID: 13519194
Thanks for the points.

If you have some time and would like to join the ranks of us experts with expert points...

Good luck on your project.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question