If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
tables with msys*
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. |
#2
|
|||
|
|||
tables with msys*
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 "John Stevenson" wrote in message ... 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. |
#3
|
|||
|
|||
tables with msys*
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 -- 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. "John Stevenson" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How: delete tables & save text? | Stan | Tables | 6 | June 22nd, 2004 07:41 PM |
Pivot Tables Rows | hans | General Discussion | 2 | June 22nd, 2004 11:26 AM |
searching for "join tables" and "join word tables" | Uncle Bill | Tables | 1 | June 11th, 2004 09:33 PM |
How do I design a database based on the information that will be stored? - Copy of Tables and hirearchies.zip (0/1) | Jim | Database Design | 1 | June 1st, 2004 01:44 PM |
Separate database for tables? | Holly Clifton | Database Design | 3 | May 18th, 2004 06:20 PM |