Spurious "form" in db

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

My FrontEnd db has a couple of forms in it that start with "~". I assume they
got there when the system crashed during development. I can open and edit the
code and the form. I can't delete the form. I would like to delete the
spurious forms. How?
 
That is a corrupt form, and in my experience they can be caused by crashes as
you described. The only way I have found to remove them is to rebuild your
database. This means creating a new, blank MDB and importing all the objects
from the old database to the new. Even if you use the "Select All" option in
the forms, the ~ form will not transfer over to the new one. I find it best
to import all the tables first, then all the queries, then all the forms and
reports, and finally all the modules or macros. You can import all objects
at once, but if you have many objects in the database, you run the risk of it
hanging, which can put a corrupt form in your new database as well.

HTH.
 
Yeah, I need to do that. The db is 2 years old and has never been recreated
like that. I started to do it, succeeded in getting all the stuff over, then
realized I needed to add 4 or 5 references I hadn't counted on. That'll take
a little longer. Thankx
 
Back
Top