what do access system tables

[Marco]

Hi. Can anyone tell what are these access system tables and for what they
stand for?

MSysAccessStorage
MSysAccessXML
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

Can I delete the data inside of any of them?

Regards,
Marco

 

[Tom van Stiphout]

On Mon, 11 May 2009 01:48:04 -0700, Marco

They are used by Access itself for its internal bookkeeping. You can
go years without ever opening these tables. By default these tables
are not shown and I recommend you keep that setting.

Why would you want to delete data from a table you don't understand?
No, that's highly frowned upon. Nothing good can come from that.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

Hi. Can anyone tell what are these access system tables and for what they
stand for?

MSysAccessStorage
MSysAccessXML
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

Can I delete the data inside of any of them?

Regards,
Marco

Microsoft has not published (to my knowledge) the internal workings of these
tables. You can figure parts some of them out by looking at the data that they
contain, and some folks have done some "reverse engineering" - but it should
not be necessary to edit or (especially!!) delete anything in them. There are
VBA tools to make any needed changes to the structure of your database encoded
in these table, and those tools will keep the structure coherent - your
meddling probably won't.

If you suspect corruption or damage in the tables, your best bet is to create
a new, empty database (with a "clean slate" of its own system tables) and
import all of the objects that you want to keep from your current database.

 

[Larry Linson]

Can I delete the data inside of any of them?

If there is a part on your automobile and you don't know what it is, are you
tempted to open it up and remove some of the components? Why? If you do, I
hope it's not connected with, say, the brake system.

You are blocked from directly modifying the contents of most System Tables.
Should you manage to circumvent the safeguards, you stand a very high
probability of making your database not only inoperable, but un-recoverable.

Larry Linson
Microsoft Office Access MVP