I run a query on the MSysObjects table in my main database to do my own searching.
From this query I generate a report of all objects matching my criteria.
Here is what I determined so far about the "Type" field in the MSysObjects table:
List of Object types=3 (Includes an object called a Script??)
Type "8" appears to have something to do with relationships. I have 2 objects in my database that are type 2
"CategoriesProducts" and "SuppliersProducts". these are relationships between the ONE tables: Suppliers and Categories, and the MANY table "Products". Yet there are similar relationships like this in my database, yet only these two are listed?
Data Access Pages=-32756
Which leads me to my question:
Does anyone know where I can get more information on the MSysObjects table?
I have heard that it is undocumented. But some ones gotta know what Type 8 really means. And what is a "Script"? Scrips are not listed in the database window?