Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

convert access 2000 mdb to 97

Posted on 2009-04-25
5
Medium Priority
?
582 Views
Last Modified: 2013-11-29
is there a way to convert an access 2000 mdb to access 97?
0
Comment
Question by:PetGuy
  • 3
  • 2
5 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 2000 total points
ID: 24234944
On the Tools menu, point to Database Utilities, click Convert Database, and then click To Prior Access Database Version

More info here on this http://office.microsoft.com/en-us/ork2000/HA011381541033.aspx
0
 

Author Comment

by:PetGuy
ID: 24235643
wen I go to the menu in access 2000 the convert to aprevious version selection is grayed out when I have no database open. When I have the database open the selection for convert database is grayed out.. Any Ides why?
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24237003
Hi, u still getting that problem? I dont know if you accepted before or after your last post
0
 

Author Comment

by:PetGuy
ID: 24238336
Access 2000 was seing the mdb as a 97 file but could see the data. 97 was not able to open the Mdb at all. I converted a copy of the file to 2000 emptyed the tables then converted it back to 97 and appended data back into the tables and it is working. Thanks for all the help.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 24238977
Cool, thanks for the update and glad you got it going.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

810 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