DB self-copying

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I would like my db to automatically copy itself every 1
hour to a backup folder. Is it possible?
 
Using a timer control, you could run various Append queries to a separate
database. If you have a form that is always open, add code to the form's
OnTimer event (after enabling the timer, of course) that would connect to
and update your backup database. Online help has some pretty good examples
of this. I'm not sure how this will affect performance, however ... and if
your data is that critical, you may wish to consider a hardware solution
(such as RAID discs setup up appropriately)
 
I would like my db to automatically copy itself every 1
hour to a backup folder. Is it possible?
Click to expand...

Not if your db is in a single file. A db file can not create a *workable*
copy of itself. But if your file is split into a so-called "front end/back
end" structure, with all the data stored in the back end, then, code in the
front end can close the back end, take a workable copy thereof, then re-open
it & continue running. You could maybe do that on a timer event.

Start by researching the front end/back end idea. It has other advantages
also.

HTH,
TC
 
Back
Top