Hello Friends
Is there any way I can get Access DB to auto close in case there is no activity for a certain peiod of time?
I am maintaining a database in MS Access and have multiple ACCDE files distributed to users for running queries that they need. I update backend database once (sometimes twice a week). If a user has local ACCDE file open I cannot update the backend DB because teh ACCDE have tables linked to the back end DB.
I noticed that most of the times users after running the query leave the session running and forget or sometimes leave it open intentionally for future use. I was wondering if I could program ACCDE files to auto close after certain period of time of inactivity. Or is there another way of dealing with this issue.
Thanks for your time
Is there any way I can get Access DB to auto close in case there is no activity for a certain peiod of time?
I am maintaining a database in MS Access and have multiple ACCDE files distributed to users for running queries that they need. I update backend database once (sometimes twice a week). If a user has local ACCDE file open I cannot update the backend DB because teh ACCDE have tables linked to the back end DB.
I noticed that most of the times users after running the query leave the session running and forget or sometimes leave it open intentionally for future use. I was wondering if I could program ACCDE files to auto close after certain period of time of inactivity. Or is there another way of dealing with this issue.
Thanks for your time
