Seems there is a hidden table. How to see it?

  • Thread starter Thread starter Blue Tide
  • Start date Start date
B

Blue Tide

I have attached the .mdb file. There is no table but I can see a table name
"Modi_Factor" in the Query.

If I try to create a new table and use "Modi_Factor" as the table name, I
see "The name you entered already exists for another object of the same type
in this database".

How can I see the "hidden" table?

Thank you!
 
I have attached the .mdb file. There is no table but I can see a table name
"Modi_Factor" in the Query.

If I try to create a new table and use "Modi_Factor" as the table name, I
see "The name you entered already exists for another object of the same type
in this database".

How can I see the "hidden" table?

Thank you!
Click to expand...

Tools + Options + View
Place a check in the Show Hidden Objects check box.
 
Still cannot see it.

If I create a new table, and use the steps you described, this table can be
hidden. However the previous hidden object still does not show.
 
It might not be a table it might be a query.

Try running the following code

' **********************
' Code Start
Function ListHidden()
Dim o As AccessObject

Const HIDDEN_ATTRIBUTE = 8&

Debug.Print "Hidden Tables"
Debug.Print "-------------"
For Each o In CurrentData.AllTables
If (o.Attributes And HIDDEN_ATTRIBUTE) = HIDDEN_ATTRIBUTE Then
Debug.Print o.Name
End If
Next

Debug.Print ""
Debug.Print "Hidden Queries"
Debug.Print "-------------"
For Each o In CurrentData.AllQueries
If (o.Attributes And HIDDEN_ATTRIBUTE) = HIDDEN_ATTRIBUTE Then
Debug.Print o.Name
End If
Next

Set o = Nothing
End Function
' Code End
' **********************

Terry


Blue Tide said:
Still cannot see it.

If I create a new table, and use the steps you described, this table can be
hidden. However the previous hidden object still does not show.

name,
I
Click to expand...
same
Click to expand...
 
Back
Top