Delete certain tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I went to change permissions to one user only, as read only. That was only
in one shared database on a network. Now, when I create a new database or
view old databases. The following tables are all displayed:

MSysAccessObjects, MSysACEs, MSysObjects, MSysQueries and MSysRelationships

How do I delete these table? To prevent them from being seen in new databases.

Any assistance will be appreciated. Thanks,

Glen
 
Hi, Glen.
How do I delete these table?
Click to expand...

These are system tables for the database, so you don't want to delete them,
even if you could.
To prevent them from being seen in new databases.
Click to expand...

Select the Tools menu -> Options to open the Options dialog window. Select
the "View" tab and uncheck the "System objects" check box. Select the "OK"
button to save your change. The system tables are now hidden in all Access
databases that you open, including the current one.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top