Delete certain tables

[Glen]

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

 

['69 Camaro]

Hi, Glen.

How do I delete these table?

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.

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.)