C
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
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