Backup file name?

[CedarTree]

Hello,

When a database "crashes", Access creates a backup named "Database_Backup". Does anyone know what name it creates if the backup file is already out there? Does it create "Database_Backup(2)" or something like that? I'm looking to delete all backup files on someone's local drive.

Thanks!

 

[Ranman256]

no, it tries to write to Database_Backup again.
you either overwrite it, or give a new name.

in the file explorer, search BACKUP,
press delete key.

 

[isladogs]

Sorry Ranman but I believe you are wrong

Access can't overwrite an existing file, so it will make a new copy
For example with a 1 at the end

This link suggests the same point: https://social.technet.microsoft.com/Forums/office/en-US/8a6a6fa8-8bd6-465f-bd22-46c82c9315a3/access-2010-database-is-creating-back-up-copies-of-itself?forum=officeitproprevious

You can test this without crashing your db.
When Access runs a compact & repair, it first copies everything to a new file called database.mdb (even if the original was an accdb) in the same folder, deletes the original file and renames database.mdb as the old file name

So create an empty database.mdb yourself in the same folder
Then run compact & repair.
This time it will create database1.mdb in order to do the compact

So the short answer is, look for anything with a name including backup