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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 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