Access 2003 timeout?
Posted on 2011-03-09
I have an Access 2003 application that is used by out about 15 people that are often accessing the database simulataneously. I am getting complaints that one user is losing information that she is entering into a query datasheet. However this is consistent. Sometimes she re-opens and some of the data was not saved, and other times it is saved. The problem is hard to re-create but I was able to determine through questioning more that she does tend to leave Access open for long periods of time when she is not at her desk, so I think that it has to do with this. During periods of her inactivity, the query has been left open, but other users have accessed the same tables that the query references and somehow their changes override what she has entered. But I'm just not sure how Access handles this type of scenario. Does anyone have thoughts of how to address this? Some type of auto-timeout for the application that would close it out after some period of time? I have tried telling her she needs to get in, make her changes, and get out, but this is not happening so I need a fix from the software side. Thanks!