Unable to open table in design view

[Jnitschke]

I am working with a database built in Access 2000 and which has been converted to Access 2007. Since the conversion, the main table is unable to be opened in design view for changes with the following message:

Either an object bound to table XXX is open or another user has the table open. do you want to open the table as read-only?

We have tried several times to open the table ensuring no other users have it open and no other objects are open and running.

Any advice would be greatly appreciated as to how to resolve the issue.

 

[Pat Hartman]

Sounds like corruption. Create a new empty database and then import all the objects into it. Don't forget the relationships. Then in the new db, open any code module and select any necessary references. Open the database options and give the database a name and select the form to be opened when the db is opened (unless you are using an AutoExec macro). Make sure to turn of "Name AutoCorrect" and turn on Compact On Close if necessary.