Link to home
Start Free TrialLog in
Avatar of paulmcneil
paulmcneilFlag for United States of America

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_E7D0A31B84294BE3B678A286FF7FEEB9_Data". The query shows that this object is a Type=1 which would be a local table, but f_E7D0A31B84294BE3B678A286FF7FEEB9_Data does not appear in the navigation pane even with navigation options set to show system and hidden objects. What is this table?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

I have never seen a table name like that?
It may be a "Internal" table or temp table, or simply the result of corruption...?.

But try querying it anyway!
;-)

SELECT *
FROM f_E7D0A31B84294BE3B678A286FF7FEEB9_Data

Let us know what you get...

;-)

JeffCoachman
ASKER CERTIFIED SOLUTION
Avatar of Luke Chung
Luke Chung
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial