Missing Data

[MomO3]

Access 2007 is losing data. I added and udpated records for several hours
today. I was able to run reports on the data ad even see it in the datasheet
mode when looking at the table. However, after I quit Access then came back
in, all the changes I made today are gone. No sign of them in the forms,
reports or tables themselves.

I have the data separated from the front end with both running on my
machine. No error were encountered when entereing the data or quitting
Access. This happened one time before. I had to export the data then recreate
the backend database to get data to be saved again. After that it worked fine
for 2-3 weeks, until today. I am baffled.

Any ideas?

 

[Maurice]

Hmm, sounds like this cannot be possible. You actually updated and added data
right? At that point it is in the database so there must be something else
going on. You state that you work with a split db, are you sure you are
looking at the front_end which is linked to the correct backend or is it
maybe linked to an old backend?