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