deleted information

[Beth]

I opened one of my databases a few weeks ago, after adding
data to it in the morning it took a long time to load in
the afternoon. When it did open it said that a record had
been deleted. I had not deleted any records nor made any
changes to the database other than add records but my link
of the main form to the sub form is no longer working. I
went in to the design view and all the information is
correct for the link. Does anyone have any ideas as to
what happened and how I can fix this without having to re-
create the entire database?

 

[Van T. Dinh]

Have you been Compacting and Repairing the database regularly?

If it is badly corrupted, try also the JetComp.exe (a "Repair" utility you
can download from Microsoft.

See also Tony Toews' article:

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