Stop Access Being Re-opened for a Specific Time - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Stop Access Being Re-opened for a Specific Time

Robert Freeman

7 months ago

Hi all. I have users who are closing a DB and then immediately re-opening it (for some reason) which is creating conflicted versions. Is there a way I can get the DB to check to see when it was last closed and set a timer to stop it being re-opened to quickly.
Has Richard covered this somewhere??

	Alex Hedley @Reply 7 months ago
Blackout Times

	Alex Hedley @Reply 7 months ago
How is it creating another version? Is this a split front end and back end?

	Robert Freeman OP @Reply 7 months ago
The database is not currently split. As to how/why the conflicted copy is created - the users say they only open the database once but clearly they do not as according to the login/logout records, there are two sessions within seconds of each other. It's very confusing.

	Alex Hedley @Reply 7 months ago
So is another db file being created with a different name?

	Donald Blackwell @Reply 7 months ago
If Access crashes or doesn't shut down properly, when it tries to open again, it will often prompt to or just automatically try to create a backup version of the database. Especially if accessed from an unreliable network or external drive or USB drive.

	Robert Freeman OP @Reply 7 months ago
Alex, it just creates another copy and marks it as '(Conflicted copy)'. I think I know the reason but I'm in the course of checking it out. Thanks for all your comments.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View