Question table 'MsysCompactError' ???

[Guus2005]

After compacting a database in Access 2003 the above table appears. It contained two records.
Compacting again: one record remains.
Compacting again: table disappeared

What is going on and how should i proceed? Can i trust the resulting database or should i follow the advice in the next link?
http://www.technewsgroups.net/group/microsoft.public.access.gettingstarted/topic19415.aspx

Here's the sample database

 

[Banana]

You made a backup, right?

I'd want to do a query comparing the table in backup against the compacted table and see if it looks right.

Something like this:

SELECT * 
FROM [C:\MyPath\MyBackup.mdb].MyTable AS b
INNER JOIN MyTable AS c ON b.ID = c.ID
WHERE c.Col1 <> b.Col1 OR c.Col2 <> b.Col2 OR c.Col3 <> b.Col3;

 

[Guus2005]

I am using the development database. Production works fine.

I have used Access since version 2.0. Never came across this error before. It is not an error per sé, because it doesn't give you one. If you don't notice the new table one might think everything is a-ok!

I will try your compare query. The number of records is not changed.

Xenos...

 

[Banana]

I never saw it myself either and would be inclined to be suspicious. It's possible that it healed from whatever error it had, which would be a good reason why it didn't bother you with it, instead merely recording it in a system table. But I'm sorta of person who would rather be notified that an error occurred but it was taken care of than silently handling the error and giving me "A-OK" sign.