Backup of an Access Database while Running.

[mwgallo]

I've been trying to backup an access database with the windows
scheduler in windows XP, but I encountered a problem, and that is an
error saying that my database was not backed up because the database
was still running, I CAN NOT STOP THE PROCESS in order to back it up,
because several people use the database on a regular basis. And we need
to back it up every two hours.

COULD ANYBODY PLEASE LET ME KNOW OF AN APPLICATION THAT PERFORMS ACCESS
BACKUPS EVERY TWO HOURS, AND THAT IT WILL ALLOW TO BACK UP THE DATABASE
WITHOUT HAVING TO STOP THE ACCESS PROCESS AND THEREFORE WON'T CRASH
WHILE DOING IT.

Many Thanks,

MG.

[Bob Alston]

Chuck Grimsby wrote:

On 2 Feb 2005 09:07:52 -0800, mw*****@tecopartners.com wrote:

I've been trying to backup an access database with the windows
scheduler in windows XP, but I encountered a problem, and that is an
error saying that my database was not backed up because the database
was still running, I CAN NOT STOP THE PROCESS in order to back it up,
because several people use the database on a regular basis. And we need
to back it up every two hours.

COULD ANYBODY PLEASE LET ME KNOW OF AN APPLICATION THAT PERFORMS ACCESS
BACKUPS EVERY TWO HOURS, AND THAT IT WILL ALLOW TO BACK UP THE DATABASE
WITHOUT HAVING TO STOP THE ACCESS PROCESS AND THEREFORE WON'T CRASH
WHILE DOING IT.

No such thing!

Switch to SQL Server or MSDE as your data storage device rather then
JET.

You know, I never did this before, as I always ran my backups at 2 am.
But I did a test and used dos copy and xcopy on an open database. Both
worked.

suggest you do some google searches and see what you find.

Bob

[mwgallo]

I've tried it before by just right clicking on the database and copying
it to another folder in a windows environment, an it works.
I would just like to do it in an automatic fashion, like I mentioned
before, the scheduler in windows doesn't work which is ironic since the
copy and paste commands are found in windows as well.
Thanks,
MG.