Records not being saved

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?
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top