Records not being saved

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Are there any circumstances under which data that is
entered manually into a table is not saved? I have a
power user that spent serveral hours entering data into a
table. She opened the database the next day, and all the
information she entered was gone. The "Date Modified" on
the MDB file was an old one, before the day all the data
was entered.

I checked the obvious, whether it was entered into the
wrong database, or wrong table. I don't think the
database was overwritten. The user didn't notice anything
out of the ordinary, no error messages.

I haven't been able to duplicate the problem, and I have
since "Compacted and Repaired" the database.

Can a database get corrupted such that the data entered
is not saved, and no error message is displayed?
 
If the date of the MDB file was an old one, she has either opened a
different copy of the database (e.g. opening it from another folder or
drive), or else her network administrator has restored an old copy.

Access always changes the file date whenever you open the file - even if you
don't make any changes.
 
Back
Top