In Access I would like before I start a procedure to make a back up of my database

I would like to create a macro to make a copy of my split data database when I click on a button. I would like to make a back up before we do payroll bi monthly.

Microsoft Access

Last Comment

cres1121

8/22/2022 - Mon

Dale Fye

2/26/2016

as long as there are no other users logged into the database, you could use the CompactDatabase method. The syntax is:

dbengine.CompactDatabase SourceName, DestinationName

but first you need to make sure that no one is logged into the Source database.

Dale Fye

2/26/2016

I'm sure you could also use the Filecopy command, again assuming that the backend is not already open.

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

2/26/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION