Disable Auto-prompt to create backup for ACCDE

[Mohsin Malik]

Hello everyone,

I have a question about the accde version of the database that I distribute to the users, sometimes the application crashes unexpectedly and prompts the user to create a backup of the accde file. This is very annoying and confusing for the users, and I want to fix this behavior so that it does not prompt to create a backup.

Is there a setting or an option that I can change in the accdb version before creating the accde file? Or is there a way to disable the backup prompt in the accde file itself? I appreciate any help or suggestions. Thank you for your time and attention.

 

[AccessBlaster]

Maybe you need better error handling or the code is a bit janky.

 

[ebs17]

sometimes the application crashes unexpectedly

I wouldn't consider something like this normal. With proper error handling that goes well beyond "On Error Resume Next", you will usually end up with a controlled termination instead of a crash.
Carrying out the programming cleanly, correctly and in a way that conserves resources would be another tip.

 

[Mohsin Malik]

Thank you for the suggestions. The application already uses VBWatchDog as well as local error handling to prevent unexpected crashes. However, the crashes that occur sometimes are not happening to all users, and they are not always reproducible.

I only want to disable the backup prompt for ACCDE version to the users because they have a batch file that always lets them get the latest version of the ACCDE file. I appreciate the help and suggestions. If you have any other suggestions, please let me know.

 

[The_Doc_Man]

The problem is that when Access sees fit to make that backup copy, it thinks something is SO seriously wrong that would end up losing data if it exited without that special backup. For you to be able to stop it, you would have to intercept the error that causes it. Never mind what the users see. YOU need to see what is causing this fatal condition and head it off. To prevent the users from seeing this, find it and fix it.

While I would not say my opinion is definitive, I don't know of a setting that would prevent that auto-backup behavior because it is being handled by Access itself, not anything in your code.

By any chance is this an O365 64-bit situation?

Redirecting

This next link is a commercial site with a product to sell and I DO NOT PERSONALLY RECOMMEND their product - because I have no experience with it - but the first six items in their list relate to the problem of that auto-backup.

Microsoft Access Keeps Crashing While Opening Report

One of the most common issues faced by users when working with MS Access is that it crashes quite frequen

www.stellarinfo.com

One of our members, Missinglinq, responded to a similar problem on another forum and suggested that if you have "Compact On Close" option selected, deselect it immediately.

So far, NO articles I have found suggest a way to intercept the backup action.