Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / July 2004

Tip: Looking for answers? Try searching our database.

tables with msys*

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Stevenson - 29 Jul 2004 19:55 GMT
I have recently started using Access 2003 and notice that
when I make a new database it automatically will add
tables that begin with msys (as example msysobject). I
can't delete these but don't know what their purpose is.
Can anyone explain this for me? I have searched all over
the internet and in microsoft without help.
Craig Alexander Morrison - 29 Jul 2004 21:22 GMT
John

These are system generated tables to manage the objects in the database they
can be hidden by using.

Tools, Options and on the View tab you can uncheck Show, Hidden Objects and
System Objects.

You generally do not need to know about these tables for most standard
applications and database designs.

--
Slainte

Craig Alexander Morrison

> I have recently started using Access 2003 and notice that
> when I make a new database it automatically will add
> tables that begin with msys (as example msysobject). I
> can't delete these but don't know what their purpose is.
> Can anyone explain this for me? I have searched all over
> the internet and in microsoft without help.
Allen Browne - 30 Jul 2004 06:31 GMT
Access uses these tables to store information about what is in your
database. They are absolutely crucial, i.e. if you could delete them, your
file would be corrupted and useless. If you do not wish to see them, uncheck
the Hidden and System boxes under Tools | Options | View.

The use of the tables is undocumented, but in some cases you can guess their
purpose from their names. MSysObjects is the most interesting. When you
create a new table, you will see a new entry there showing the name of your
table, and Type is 1. Create a query, and a new entry shows up in
MSsysObjects with Type 5. Your forms are all there as type -32768, reports
as type -32764, and modules as -32761. Attached (linked) tables are type 6,
or type 4 for ODBC linked tables.

If you wish to follow up some other examples, Stephen Lebans has done some
work on how Access stores the relationships window data:
   http://www.lebans.com/saverelationshipview.htm
and michka has done some work on how it stores the import/export specs:
   www.trigeminal.com

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have recently started using Access 2003 and notice that
> when I make a new database it automatically will add
> tables that begin with msys (as example msysobject). I
> can't delete these but don't know what their purpose is.
> Can anyone explain this for me? I have searched all over
> the internet and in microsoft without help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.