paulmcneil
asked on
MS Access table not listed in navigation pane
I'm using a query of MSysObjects in Access 2010 so I can loop through the data tables in the database. One Name that appears in the query results is "f_E7D0A31B84294BE3B678A28 6FF7FEEB9_ Data". The query shows that this object is a Type=1 which would be a local table, but f_E7D0A31B84294BE3B678A286 FF7FEEB9_D ata does not appear in the navigation pane even with navigation options set to show system and hidden objects. What is this table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It may be a "Internal" table or temp table, or simply the result of corruption...?.
But try querying it anyway!
;-)
SELECT *
FROM f_E7D0A31B84294BE3B678A286
Let us know what you get...
;-)
JeffCoachman