Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: MSysObjects problem

    Hi All,

    I have a problem compacting a 13Mb db. It gets partway through and then I get the error:
    "Record(s) can't be read; no read permission MyDB.mdb".

    I open the db I have compacted to - db1.mdb, and there is a MSysCompactError table, I open this and find that it is having problems compacting the MSysObjects table. True enough I go back to MyDB.mdb and I can't copy/paste this table (although it is possible to copy/paste it in all other dbs I manage).

    So I'm guessing that I need a new MSysObjects table for this db (unless I want to go back and create the thing from scratch...). Does anyone have a better idea - or have come across this problem before?

    Or know an easy way of creating an MSysObjects table (is it possible??).

    Grateful for any advice....

  2. #2
    Join Date
    Sep 2003
    I had a similar problem with one of my databases. I created a new database, then imported all my objects into the new, empty database (tables, queries, reports, etc). Do not import any of the MSys tables. The new database will have its own MSys tables and you should no longer have an issue with them being corrupt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts