Disappearing data

[kenrav]

Several months ago, I developed an Access 2007 split database application for
several users around the country. Both front-end and back-end are .accdb
files. All has been fine.

Yesterday, I compiled the FE as an .accde and installed it on a new user's
PC. I left the BE as is. The weirdest thing is now happening; after awhile,
all the data in one of the BE tables disappears! Unfortunately, I can't
duplicate the problem here.

Any ideas? Thanks.

 

[Jerry Whittle]

1. Exactly how do you know that the data is missing? Have you opened up the
BE to make sure at the source?

2. Did you have any code which removed data from that table for any reason?

3. Is the new user trained how to properly use the database?