when creating a new database it includes extra tables

[Chris]

when creating a new database it always includes extra
tables.
The tables are the following:

MSysAccessObjects
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

Does anyone have a clue how to fix this???

Thanks,

 

[John Vinson]

when creating a new database it always includes extra
tables.
The tables are the following:

MSysAccessObjects
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

Does anyone have a clue how to fix this???

These are the Access systems tables which contain all your table
structures, query SQL, your Forms, your Reports, everything. Deleting
them is a) impossible and b) not a good idea since it would destroy
your database!

Hide them instead. By default the Tools... Options... View... Show
System Objects checkbox is unchecked; it's somehow gotten checked in
one of your databases. Uncheck it and these vital tables will vanish
from view, while continuing to do their essential work unseen.

 

[kev]

Yes...turn off the view system objects in
Tools/options/view.

 

[Guest]

Thanks,

-----Original Message-----
Yes...turn off the view system objects in
Tools/options/view.
.

 

[Guest]

Thanks,

-----Original Message-----


These are the Access systems tables which contain all your table
structures, query SQL, your Forms, your Reports, everything. Deleting
them is a) impossible and b) not a good idea since it would destroy
your database!

Hide them instead. By default the Tools... Options... View... Show
System Objects checkbox is unchecked; it's somehow gotten checked in
one of your databases. Uncheck it and these vital tables will vanish
from view, while continuing to do their essential work unseen.


.