Compacting Database Problem - MSysCompactError table not found

[chuckdfoster]

I am trying to compact and repair a Access 97 Database. I can successfully
repair the database, but cannot successfully compact the database. I
recieve an error that says that the "MSysCompactError table does not exist.
Make sure the path and spelling are correct." I have tried to create that
table with the columns ErrorCode (int), ErrorDescription(memo),
ErrorRecID(Binary), and ErrorTable(text(64)). I found this info with a
external Compact Tool. This did not work either. I also tried copying an
existing system table and making the changes to the columns, but this did
not work either.

Any help or advice?

Thanks, Chuck Foster

 

[Guest]

Have you tried creating a brand new database and seeing if you can import the
objects (not the system objects) over to the new database from the old
corrupt one?

-Steve Huff
http://www.huffs.us

 

[Tom Wickerath]

Chuck,

You posted the same question on Dec. 27, and you received two answers:

Randy Balbuena wrote in message

and

Tony Toews wrote in message

Were you expecting a different answer by posting your question again?

Tom
________________________________


I am trying to compact and repair a Access 97 Database. I can successfully
repair the database, but cannot successfully compact the database. I
recieve an error that says that the "MSysCompactError table does not exist.
Make sure the path and spelling are correct." I have tried to create that
table with the columns ErrorCode (int), ErrorDescription(memo),
ErrorRecID(Binary), and ErrorTable(text(64)). I found this info with a
external Compact Tool. This did not work either. I also tried copying an
existing system table and making the changes to the columns, but this did
not work either.

Any help or advice?

Thanks, Chuck Foster

 

[chuckdfoster]

No I was not expecting different answers. I just couldn't find my post.
Thanks for the links to them.
I have tried JetComp and it was unsuccessful as well.

I am currently using a backup, but it will not Compact either. I don't know
when this problem occurred, so I don't know how far back to get my backup
from.

Luckily, I am linking to another Access Database that keeps all of the
tables. I do that incase of a problem like this, I won't lose any data.