corrupted query?? Need help to fix.

[Guest]

I know very little about Microsoft Access.

We have a database that we use at our company that was designed many years
ago (files in it go back to 1994).

It is so old that no one knows who created it, and no one in the company has
any experience with Access. We have an IT person who we call when we need
help, but he is gone for two weeks on vacation (we are a small company). So,
being that I am the only one with any IT experience, they asked me to look
into it.

This morning, when we click on entries in the database, blank forms come up.
When we are clicking on an item in the list, it should come up with the
information that was entered on that form.

THe data is there (went to forms view) but it appears that the "link" for
connecting the list with the data in the form view is corrupted (sorry if
this is not the correct wording, but I don't know how to explain it better).

It was fine at 5 pm yesterday, but as of 5:30 am this morning, it was
corrupted, so it may have happened overnight during the backup.

The wednesday backup is fine, but we need the data that was entered on
thursday to be carried over somehow.

Is there an easy way to fix this? Merge the documents somehow? I could
easily just take the wednesday version and replace the corrupted thursday
one, but we would lose all the data entered yesterday.

Any suggestions? I think the correct thing that is corrupted is the "query"
for taking the info from the list and showing it on the form.

 

[Guest]

You might be better off using the backup file as you admit to having a
limited knowledge of Access. Have you tried a compact and repair yet?

Below are some resources about corruption issues. Many of the things
discussed assume a high level of Access knowledge.

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

 

[Guest]

I reviewed the links but it's like russian to me. I have no idea what most of
it refers to, and because this is a VERY important database, I don't want to
screw anything up!

I will see if I can find an employee next week who can to spend a few hours
re-entering the data from thursday into the wednesday copy. That may be the
best option.

Thanks anyway!

 

[Guest]

If you'd like, I can be contacted at (e-mail address removed)