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!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to delete MSysObjects, MSysACEs, MSysQueries 1

Status
Not open for further replies.

4Wile

Programmer
Jul 16, 2001
25
US
I can not delete MSysObjects, MSysAccessObjects, MSysQueries, MSysRelationship, MyAccess..There all tables that showup on every new Database. I have reloaded my
MSOffice and its still there...The message is (Typically)
"The Database engine could not lock table 'MSysObjects' because it is already in use by another person or process"
I have MSOffice 2000 developer system , I need help...I'm Lost...
 
Why would you want to? These are the tables used by Access to store the information about all other objects in your database.

Dave
 
I can not find a reference to the tables...

I have started a new database and they appeared..Are they
necessary or ??
 
I can not find a reference to the tables...

I have started a new database and they appeared..Are they
necessary or ??
 
They are required. If you don't want to see them go to Tools->Options->View and uncheck the boxes for Hidden Objects and System Objects.

Dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top