Hidden System Table ??

[MattS]

I used some code to run through all the Table Defs and print the name in the debug window. Included in the list were the hidden system tables (i.e. MSysAccessObjects), but when I go to options and make them visible, there is one from the list that does not appear:

MSysCompactError

I am having problems with this database, and am wondering if this could be the key. Does anybody know what this table is, or what it holds?

Thanks for any help,

Matt.

 

[MattS]

The code I used is:

-----------------------------------------------
Public Sub sListTables()

Dim tdef AS TableDef

For Each tdef in CurrentDB.TableDefs
Debug.Print tdef.Name
Next

End Sub
------------------------------------------------
Then I just called the routine from the debug window.

NB: the database compacts/repairs ok, and the code compiles.

 

[MattS]

Use this in the:
>>>Start<<<
>>>Run<<<
box

Not sure I understand what you mean. Are they DOS commands??