0

There are two large (5 GB each) DBF files that need to be backed up before a process is run via MS Access. This is in case something gets corrupted.

Right now I am doing two filecopy() commands within the VBA but I suspect it is slow.

What is the best way to perform this backup automatically and efficiently? Can it be done from a batch file or something similar? I cannot install new software.

user4912610
  • 3

1 Answers1

0

Using a batch file here's what you can do:

COPY FILE.DBF B:\Backups
COPY FILE1.DBF B:\Backups

Another way to do it is using the command Esentutl (Windows Vista+)

ESENTUTL /y FILE.DBF /d B:\Backups\FILE.DBF
ESENTUTL /y FILE1.DBF /d B:\Backups\FILE1.DBF
td512
  • 5,170