Re: Form Dirty not firing

I have already checked out the suggestions at the website you
mentioned. I could not tell if what I am experiencing is related to
error ridden code or corruption. I suspect corruption but wanted to
avoid that pain if I was unsure.

Backups are not a problem. I keep multiple copies as a history on two
different drives. I make a dup every few hours just in case as a
standard procedure.

There are no Reference issues. I have Compiled and do so frequently
after many code changes. I verified that all forms are set to Option
Explicit and added error handling to every procedure and function. I
have compacted and repaired many times. Every time the app crashed it
also forces me to do a backup and compact and repair again.

I guess my next step is to decompile. If that does not work how do I
determine if I need to rebuild the form that is causing the current
trouble versus rebuild the whole database in a new container?



Check out the suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

YOu'll certainly want to MAKE A BACKUP (some of the cleanup procedures can
ironically destroy databases)

Some steps:

Open the VBA editor and select Tools... References. Remove or resolve any
MISSING references.
Select Debug... Compile; fix any code errors. Iterate until no errors.
Use Tools... Database Utilites... Compact and Repair.

It may be appropriate to Decompile (see how on Tony's page).

It is sometimes necessary to create a new empty database and import everything
to get rid of rubbish that Compact and Repair misses.

John W. Vinson [MVP]


.

Relevant Pages

  • Re: #Name? error
    ... Have you done a compact and repair, or a decompile followed by compact and ... What happens if you create another database as a test, keep it simple, use ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
    (microsoft.public.access.forms)
  • Re: Access Crashes When Rt Click Build in Query Design View
    ... Since you disabled Name AutoCorrect and decompiled and compact/repaired and fixed references and now have fully compiled code and then recreated the query, I'm not sure what alternatives might help. ... And it will happen on more than one query in the database. ... Compact the database to get rid of this junk: ...
    (comp.databases.ms-access)
  • Re: Access 2003 Possible Corruption?
    ... Jana, you've had some good answers, but this seems like an important enough ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ...
    (comp.databases.ms-access)
  • Re: Add Record button Gives error
    ... database, I chose to copy and past each of these into a new blank database, ... Compact the database to get rid of this junk: ... Choose References from the Tools menu. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: Names of textboxes on tab-pages within a tab control?
    ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ... Still in the code window, choose Compile from the Debug menu. ...
    (comp.databases.ms-access)
Loading