Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 to Access 2000

Status
Not open for further replies.
ElmoFringby30

ElmoFringby30

Programmer
May 24, 2001
10
0
0
US
How do I convert an Access 97 based Database to work in Access 2000?
 
Sort by date Sort by votes
Well if you open the file with Access 2K, it should autoconvert the database for you.. and copy/make a backup of the 97 one.

 
Upvote 0 Downvote
In Access, under Tools, Database Utilities, Convert Database, you should have "To current Access database version". This will convert you 97 DB to 2000. Once it has been converted, if it contains any Macros, open the database, click on Modules, go to View, Code. In the Window that pops up, go to Debug ,Compile "database name".

HTH

Indu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Office 2000 XL
Replies
6
Views
348
dhookom
dhookom
pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
91
combo
combo
TrekBiker
  • Locked
  • Question
Using Access Remotely
Replies
2
Views
50
dhookom
dhookom
techie131
  • Locked
  • Question
MS Access Query
Replies
2
Views
52
techie131
techie131
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
244
teknance
teknance

Part and Inventory Search

Sponsor

Back
Top