Front End Back End Backup

RangerTen

Rangers Lead The Way!
Local time
Today, 17:50
Joined
Jun 30, 2002
Messages
42
I am creating a split database for various reasons. Is there an easy direct way to create a cmd button (in the front end) that would copy the backend .mdb to a location of the users choice as a security measure (backup)? Would that have to be coding through the windows API or does access/VBA have the capabilities to do it?

Thanks for the help.
 
Last edited:
Use the filecopy statement. Syntax is just

Filecopy source,destination

However, you can't use it on a "currently open" file, so I'm not sure whether Access would consider you linked backend as "open".
 

Users who are viewing this thread

Back
Top Bottom