How to clean up MSysObjects

B

Brian

Is there a way to clean up the references to all the deleted objects in
MSysObjects without creating a new DB and importing objects?

When beginning a new application, I generally save myself a lot of work by
copying one MDB to another as a template, remove some objects, leaving in
place several modules and a few sample forms & reports to use as templates in
the new application.

I just noticed that my MSysObjects table has references to a host of
nonexistent objects - ones that I have deleted from various applications over
the years. In addition, I had one particular form in my current application
that repeatedly became corrupt (would not open that form in any mode; no
access to its module), requiring me to retrieve my entire app from backup and
re-doing work--four or five times now.

I tried importing the form to another DB and got a "no current record"
error, which is what prompted me to suspect a broken object reference and
look through MSysObjects for its reference, in turn revealing all the ghost
references.

In the end, I just created a new MDB and imported the objects from a
pre-corrupted version of the new app. However, I then had to go through
several settings (like turning off name AutoCorrect and Subdatasheet Name) as
well as creating a couple of custom DB properties I use on all my apps.

Decompile does not seem to remove all the old object references.
 
B

Brian

Well, getting to what prompted my question: my form was again corrupted, even
after creating a new DB, so maybe this question is not relevant. I will post
a new under under the subject Form repeatedly becoming corrupt
 
J

John W. Vinson

Well, getting to what prompted my question: my form was again corrupted, even
after creating a new DB, so maybe this question is not relevant. I will post
a new under under the subject Form repeatedly becoming corrupt

Probably time to create a new database and import all the objects EXCEPT this
form... and rebuild this form from scratch (or at the most, create a new blank
form and copy and paste the controls).
 
J

J. Dan

Hi
I have quite similar ( but slightly different) problem with MS ACCESS 2007

It seems that it is somehow relate to the new fields types additions which are "Memo" with AppendOn and "Attachments"

On relinking of tables which uses such fields causes the same problem described above. Compressing and Fixing the table does not help.

I found that even if I remove the tables and restores them does not necessarily help. I found that it might be related to this table "MSysComplexColumns" which holds information and references about the "attachments" type field. Even when I remove the said tables the records in "MSysComplexColumns" still reside

Is there anyway removing these entries "MSysComplexColumns" is a system table. protected from writing) and by this recovering the links

Thanks

J. Da
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top