after crash forms display #NAME?

[idtjes3]

Hello,

I was working on my Db when all of a sudden it crashed. I saved a backup
and closed it down. I opened the back up and now on my main " Job
Information" form, almost all of my text boxes with equations display
"#Name?". Some of the text boxes reference other tables, some other forms,
and some the same form they are located on. I checked the data source an a
select few boxes and all the data, according to my table, is correct. Its
worth noting that the entire DB was working perfectly before this crash.

Now if i go into design mode for the form, delete any text box, then
using the "add existing field" menu drag the text box back onto the form, All
of the text boxes including the one i draged in will then display the correct
data. I then save the form, save the database and close it. When i open it
back up however, all the boxes display #Name? again. Ive also noticed that
before the crash the file was around 8mb now its 1.6mb. Is there a way to
restore the DB to its working form? What happened to the other 7megs of my
data?

 

[Tom van Stiphout]

On Tue, 22 Jan 2008 18:21:10 -0800, idtjes3

The best way to restore the DB is to restore the db. That is, restore
a previously made backup. If you don't have one, you have joined the
club of sadder but wiser men.
The file size difference is because of compacting. Nothing to worry
about.
#Name? could be because the table or query underlying your form is
corrupt or not the version you think it is. Inspect that first.

-Tom.

 

[idtjes3]

Thanks thats what i was afraid of. What about this repair and compile option
ive heard about?

 

[Tom Wickerath]

What about this repair and compile option ive heard about?

That would be "Compact and repair database". With the database open, in
Access 97 through 2003, click on Tools | Database Utilities...| Compact and
repair database.

If you are working in Access 2007, you need to click on the Office button |
Manage | Compact and Repair Database.

If this does not fix the problem, then try the steps outlined in my Access
Links.doc Word document, on page 3, in the section that is titled "My
standard advice for attempting to fix minor corruptions". You can download a
copy from here:

http://www.accessmvp.com/TWickerath/


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[idtjes3]

Thanks alot Tom you might have saved me the headache of loosing a day of
work. will try when i get to work.

 

[Tom Wickerath]

Let me know if that is enough to fix the issue. If the problem still
persists, I still have a few more things that you can try out.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________