Unwanted prompt to backup database

[fryeste]

So I've got this Access application that I developed. One user encounters a dialog box at a certain point in the workflow prompting them to backup the database. When they do - or if they cancel - the application terminates.

Any ideas about why this is happening? There is no known VBA code within the application that would generate this occurrence. Settings somewhere?

Thanks,
Steve

[ranman256]

this happens when theres a corruption. some form/report is broken when it tries to open it.
this triggers an error and the db will backup to MyDb_backup.accdb.

be sure you can open all forms/reports/queries without a crash.
compact repair.

[fryeste]

Thanks for this. I'll have to check what's being called at that point - most likely a report.

Steve

[CJ_London]

make sure your db is split and each user has their own copy of the front end on their machine. Not setting it up this way is the most common reason for corruption

[fryeste]

Yup, sure is. Been developing Access applications for close to 20 years, and always set up multi-user apps this way, including this one.

Whenever possible, I also set things up to automagically download a fresh master copy of the front-end from a server to the workstation whenever the user logs in. Keeps things clean on the workstation and also distributes updated versions without other special handling.

Steve