Solved

Convert Access 97 to Access 2003

Posted on 2004-04-10
8
2,149 Views
Last Modified: 2011-03-21
Is there a way to convert an Access 97 file to another version of Access. 2000, 2002, 2003.
0
Comment
Question by:pbelec
[X]
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
8 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 10798458
Just open it in the newer version an access will propose a conversion.

Nic;o)
0
 
LVL 54

Expert Comment

by:nico5038
ID: 10798465
But make sure before doing this that the database is "clean compiled".
Open some VBA code and select "Debug/Compile all modules"
Solve the errors first or the conversion can fail without a warning !

Nic;o)
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 10798466
Do you mean Access97 mdb (database)?

If you are using 2000, 2002, 2003
Opening the access97 db will give you an option to convert the db.

if you do the conversion, you will retain the acc97 mdb and will have a new mdb
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Accepted Solution

by:
RLGoldberg earned 500 total points
ID: 10799260
OK, the basic concept of converting an Access97 file to 2000, 2002, or 2003 is pretty easy.
1) Make a copy of the file for safety
2) Open the file in the newer version of Access and accept the suggestion of converting the file.  This will save the original file and make a new file (with a name change) in the version of Access you are converting it to.

Several issues to think about and/or do:
1) If you used code in the database that was from DAO 2.5 or earlier, this will need to be updated.  You do this from a code window (press Ctrl-G from Access to go into the MS VB code window. Go to TOOLS | References and see if you have any references that have been orphaned.  If so, pick a newer version of the reference.  Then go and compile the code DEBUG | COMPILE and check for further errors.
2) DoMenuItem has been changed to RunCommand but the DoMenuItem is still available for backwards compatibility issues.  You should search your code for the DoMenuItem and replace where possible.
3) Security enabled projects take more care in converting them do to the security considerations.
4) If problems are encountered while converting, you can find these in the Conversion Errors Table that is created.  Take a look at this and work the issues one at a time.
0
 
LVL 16

Expert Comment

by:ahmedbahgat
ID: 10799313
if the 97 version was created with security in mind then you will need to use the mdw accociated with it, or give the admin account full permissions and use any security file

cheers
0
 
LVL 12

Expert Comment

by:nexusnation
ID: 10799602
Don't forget to reference DAO 3.6 Object Library after you convert. Access 2000 up uses ADO as a base while Access 97 used DAO. So you'll need to reference DAO since you'll most likely have code using DAO in your program...

Andrew
0
 

Expert Comment

by:marcuseyers
ID: 11217191
Hi
If a 97 access file is opened and changed to be able to be read in 2000/2002/2003 and saved, can the file be read by opening it back in 97?
Cheers
          Marcus
0
 
LVL 16

Expert Comment

by:ahmedbahgat
ID: 11217583
no you will receive "unrecognised database format", unless you use the option save as prior version of access


cheers
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

624 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