Link to home
Start Free TrialLog in
Avatar of Fritz Paul
Fritz PaulFlag for South Africa

asked on

VBA to copy the database back end to a new database file.

In order to create a daily backup of our database back end, I want to copy and paste it to a new copy of the back end, when the first person logs into the database each morning.
I will like to add the date of the present day to the name of the backup copy.
It may be that someone may still have the database in use from the previous day at that moment.
Can anyone give me advice please.
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America 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
ASKER CERTIFIED SOLUTION
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
Avatar of Fritz Paul

ASKER

Thanks Guys. Brilliant.