Link to home
Start Free TrialLog in
Avatar of Gilberto Sanches
Gilberto SanchesFlag for Suriname

asked on

Options to automatically create backup of Access database

Dear experts,

What options are there in Access to automatically create a backup of the complete database at opening of the database or daily at a specific time? Preferably when the Access db is opened that a window asks the user if the user wants to create a backup of the database?
Avatar of Daniel Pineault
Daniel Pineault

If your db is split, you can at the startup, before a lock file is created on the back-end prompt the user.  If they confirm, then it is a simple filecopy.

You don't want to perform a backup while there exist a lock file.
Avatar of Gilberto Sanches

ASKER

The database is the front end & back end. That is why I want to implement a automatic backup solution.

Filecopy, hmmm, I'll check that out
You really should split your database.

As for FileCopy, see https://www.devhut.net/2010/09/29/ms-access-vba-copy-a-file/ for a function that includes some basic error trapping.
Thanks Daniel for recommending the "Split Database" & the VBA file copy codes. I appreciate it
Copying a database that is currently open by some other user can lead to corruption.  Backups should happen when all users are out of the application.
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good to know PatHartman.

As recommended, I created a split DB. I'll then schedule the backup after workhours. Thanks for the software John, I'll use it.