Discussion Locked

Access 2000 to Access 97: Compatability

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ihave an user who created an office 2000 Database, she has since downgraded back to office 97. She can't open her 2000 databases in 97. I already tried to to save it as an office 97 file but that did not work

8 replies

by pkuzniasz

As I understand Access you cannot open the Access 2K in 97. There is no backward compatibility.
Reinstall Access 2K and save it as an Access 97 file and that should do the trick.

by adynes

I've had a problem like this also. You can try a few different things:

Save the database as a Access 97 database from Access 2k. Then create a new database in Access 97 and try importing the data from the converted one. If this dosn't work try to at lease inport your old tables. This usually works.

Export out your tables from Access 2k into excel and then re-import them into Access 97. You'll have to redo the forms but at least you'll have the data and table layout.

Not great answers but if M$ did a better job on there previous version exporter you wouldn't have this problem. Theres also problems converting from Access 97 up to 2k. I had one database convet without a problem and another kept erroring out. Good luck.

Allan.

by jason fitzpatrick

One thing that you may have to watch out for is the fact that OF2K does not completly uninstall, this has been a big problem for us in here, MS do have a utility that will finish the uninstall: eraser2k.exe (U can find it on the MS downloads site) Do the standard uninstall from add remove programs before you do this.

Jay

by mde

Maybe an obvious, but overlooked answer to your problem is this. When you convert the 97 database to 2000 it makes you rename the file. If you haven't deleted the original 97 database file go back and use that one.

This discussion is closed to new replies.