Backing up open access database

[Guest]

I’m doing scheduled backups of an access database (which may be open) from
drive “C†to “D†using a batch file identifying an “xcopy†script. Can
anyone identify if I will corrupt the database in either drive if the
database is left open?

Thanks.

 

[John Vinson]

Can
anyone identify if I will corrupt the database in either drive if the
database is left open?

Yes, you almost certainly will corrupt the database.

You can do "hot backups" of SQL/Server or other client/server
databases. Access is not a client/server database but rather a
fileserver database; a backup of an open database will either simply
not run because the file is in use, or if it does, it is very likely
to leave the tables in an inconsistant state.

John W. Vinson[MVP]

 

[Bill Mosca, MS Access MVP]

Maybe I've just been lucky, but I've never had a problem when I copied an
open database. In fact, I use software called QuikSync that does an
automatic backup every hour whether the database is open or not, but that's
only on my development files.

If there is an action query running at the time you copy, you won't get the
data change. The old data will remain in the copy.

 

[Guest]

HI PERS
I am interesting about the script you write can you tell me exactly what you
have write in your batch file?
Thank you
Koulla