Solved

Convert Access 97 to Access 2003

Posted on 2004-04-10
8
2,140 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
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

786 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