Backup/Restore Backend from Frontend

K

kremesch

I want to be able to backup and/or restore the backend from the front end.
Can this be done?

If yes, could someone please point me in the right direction?

I've been searching on my own, but am unable to find a proper solution.
 
G

Graham Mandeno

Provided there are no open recordsets based on your back-end tables, you can
do whatever you like with the back-end file.

Two possible options are a simple copy of the file:

FileCopy <path to backend>, <backup file name>

or create a compacted copy:

DBEngine.CompactDatabase <path to backend>, <backup file name>
 
A

aaron.kempf

if you used an ACCESS DATA PROJECT you wouldn't have to worry about
this simple annoying crap

compact and repair shit

it's 2005 welcome ot the 90s
start using ADP
 
Top