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 derfloh 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
Joined
May 24, 2001
Messages
10
Location
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

E
  • Locked
  • Question Question
Please help with my access report
Replies
7
Views
2K
dhookom
dhookom
C
  • Locked
  • Question Question
Office 2000 XL
Replies
6
Views
1K
dhookom
dhookom
pendle666
  • Locked
  • Question Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
742
combo
combo
TrekBiker
  • Locked
  • Question Question
Using Access Remotely
Replies
2
Views
381
dhookom
dhookom
techie131
  • Locked
  • Question Question
MS Access Query
Replies
2
Views
381
techie131
techie131

Part and Inventory Search

Sponsor

Back
Top