After crash form errors.

[idtjes3]

Hello,

I was working on my DB when all of a sudden it crashed. it created a
backup and exited. I opened the back up and when i bring up my main job
Information Form, almost all my text boxes that have equations in the display
"#Name?" . Some boxes reference other tables, some forms, and some even
reference other boxes on the form itself. When i view the code for the text
boxes, everything is correct how it should be. Its worth noting everything
was working perfectly before it crashed.

Now if i go into design mode for the form, delete any text box, and drag
the same text box back onto the form from the "add existing fields" section,
everything is restored and all the "names" are filled back in. If i save the
form, save the database and exit, when i restart it, the "#name?" is back in
all the boxes again. Also, i noticed that the file size before the crash was
about 8mb no its only 1.6mb. Is there anyway to fix this? It figures cause i
was backing it up all day and it decided to crash right before i was done for
the day.

 

[Jerry Whittle]

It's corrupt. At times like this, nothing beats a good backup. In fact make
a complete backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp