Discussion Locked

Transfer of Access 97 To Access 2000 com

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Attempts to open an Access 97 database in Access 2000 results in a message regarding not being a member of the workgroup file. Access 2000 does not display the message, do you want to convert this database. I made sure I reverted to my system workgroup file with not security on before I saved the Access 97 database for the upgrade. Has anyone had this problem, do you know of a fix?

5 replies

by donq

Database ownership MUST be passed to someone (Admin) outside the workgroup before conversion.

by richtee

A possible solution to your problem can be found in MS Knowledge Base article Q232589. Some excerpts are as follows:

?When Access tries to open a database created in an earlier version, it displays a dialog box giving you the choice of opening the database as read-only or converting it to the newer version. In the case of a secured database, the Convert/Open Database dialog box will not appear if you are not the owner?

?Although you may have met all the conditions of the error message, if you are not the owner of the secured database, you may not be able to either open or convert the database.?
?To convert the database to the newer version, you can do one of the following:
If you are a member of the Admins group, change the permissions on the system tables to include Administer.

-or-

Have the database owner convert the file.?

Hope this helps.
Rich

This discussion is closed to new replies.