Flags in MSysObjects table (Access 97)

[Graham Luckhurst]

Does anyone know a source of information on Flags field in MsysObjects
table?

Can anyone confirm that a hidden report has a Flags value of 8? Also
queries have a Flags value exactly divisible by 16 unless they are hidden
when and extra value of 8 ADDED is there Flags value.

The following SQL will display all the Queries { MSysObjects.Type=5 } that
are NOT hidden
(([MSysObjects]![Flags]/16)-(Int([MSysObjects]![Flags]/16))=0) }.

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=5) AND
((([MSysObjects]![Flags]/16)-(Int([MSysObjects]![Flags]/16)))=0));

Can anyone see a fault in this reasoning?

[Michael (michka) Kaplan]

No need to crosspost to so many groups.

Just so you know, anyone who would be in a positon to tell
you this information officially is under an NDA
(non-disclosure agreement) and cannot do so.

You can always look yourself through trial and error and
hope you did not miss anything.... but just setting
realistic expectations here.

--
MichKa

-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)

random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com

Graham Luckhurst <grahaml...@yahoo.com> wrote in
message news:ba4N3.32$i46.1992@news2-hme0...

[Patrick McCarthy]

It looks like the flag field is actually a bit manipulation field using
1,2,4,16, 64 etc for bitwise manipulation - in your example the 16 =binary
bit 5 and 8 = binary bit 4

readup on bitwise manipulation

Michael (michka) Kaplan <forme...@nospam.trigeminal.nospam.com> wrote in
message news:#2uSkzaF$GA.248@cppssbbsa05...