By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,101 Members | 971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,101 IT Pros & Developers. It's quick & easy.

Backup of an Access Database while Running.

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.