Exporting List of Access Objects

[JMichaelM]

Using the exporting method of tables and queries
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=5));
Im seeing various named items that don't show up on the access objects even with all navigation unhidden.

For example:

Table Name MSysObjects MSysACEs MSysQueries MSysRelationships MSysComplexColumns MSysComplexType_UnsignedByte MSysComplexType_Short MSysComplexType_Long MSysComplexType_IEEESingle MSysComplexType_IEEEDouble MSysComplexType_GUID MSysComplexType_Decimal MSysComplexType_Text MSysComplexType_Attachment



Queries

Query5 Name ~TMPCLP278681
Name ~sq_cDiabetes CDC~sq_cCTRL#_cbo

Why is this and what are these items?



Thanks

 

[Ranman256]

These are deleted queries. They are NOT supposed to show.
One PC I use will show them, other do not.
I think it's a bug. When you compact they go away.
They SHOULD go away.

Ignore them.

 

[JMichaelM]

Thanks. It makes sense what about the ones from the tables. MSSyt Objects

 

[The_Doc_Man]

Not only deleted queries. When you use a wizard to build a query for combo box or list box, you will get one of those oddball "funky-name" queries.

Ranman is absolutely right, however, that they are not supposed to show up as a normal query. If the VBA code in a class module is not in a general module, then this other use of queries is like a "class query" that won't show up in the general queries.