Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Code Archive _ Msysobjects Flags

Posted by: raskew Feb 7 2004, 08:43 PM

Recently ran into a variation of this query, intended to return information on an application's tables and queries:

CODE
SELECT
 MsysObjects.Name AS ObjectName, IIf([type]=5,"Query","Table") AS ObjectType, MsysObjects.Type, MsysObjects.Flags
    FROM MsysObjects
    WHERE (((MsysObjects.Type) In (1,5,6))
    AND ((MsysObjects.Flags) In (0,16,128,2097152))
    AND ((Left$([Name],1))<>"~")
    AND ((Left$([Name],4))<>"Msys"))
    ORDER BY MsysObjects.Type, MsysObjects.Name;

I was a little perplexed about the MsysObjects.Flags and how they figured into the equation.
Apparently, they are undocumented but, with a little research, came up with this listing of definitions. Can't guarantee it's complete, but think it's probably pretty close.
Understand that this is probably something that most of us will never use, but it might be useful to tuck it away somewhere for future reference (just in case):
Append = 64
Crosstab = 16
Data-Definition = 96
Delete = 32
Deleted or temp ( prefixed with ~) = 3
Hidden = 8
Linked Table= 2097152
Make-Table = 80
MSys Table (w/o read permission) = 2
MSys Table (w/ read permission) = -2147483648
Select Query or standard table = 0
Union = 128
Update = 48
Best wishes -- Bob

Posted by: tvanstiphout Dec 25 2014, 11:31 AM

> Linked Table= 2097152 (20 0000 hex)
That is certainly true (as long as you mean a linked Access table), but values of 2359296 (24 0000 hex) can also occur. I don't know yet the significance. It does not appear to be the difference between a standard Access table and an A2010 web database table.
Then you can OR this with the Hidden value of 8 if your linked table has the Hidden attribute set.

-Tom.

Posted by: DanielPineault Aug 26 2016, 01:18 PM

Came across the following flags, but haven't figured out their significance completely, but this is what I could extrapolate.

Not sure what they represent, but the TableDefs collection does not include such tables
-2146828288 -> f_*_Data tables
-2147287040 -> MSysComplexType_* tables


10 -> MSysNavPaneGroup* and MSysAccessStorage tables


No clue
262154