[AccessD] Hourly Backups Of Access Data

Howdy
I suppose it depends upon the database, but the 'techie' guy I work with has
put in place some little .bat files that copy the database on the hour to a
particular directory and depending upon the .bat file and time, places it in
a 1100, 1200, 1300 etc directory.  That way if we can go back to any time in
the last 24hrs without going to the nightly backup tapes.  It works very
well, he had to put some commands in the startup of the server to do it,
(I'm not up on that side of things in case it's not painfully obvious) but
it certainly doesn't kick anyone out whilst performing the copies.  I
suppose you could add a line to the .bat file to compact them.
Cheers
Selina

----------------------------------------------------------------------------
---- Selina Iddon selina at easydatabases.com.au Ph: 0414 225 265 Easy Access
Databases
----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Tuesday, November 04, 2003 3:42 AM
Subject: RE: [AccessD] Hourly Backups Of Access Data


> Ya, just import them into a new db.  You should be able to import them
> without having to kick anyone out!
>
> Drew
>
> -----Original Message-----
> From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net]
> Sent: Monday, November 03, 2003 11:00 AM
> To: accessd
> Subject: [AccessD] Hourly Backups Of Access Data
>
>
> To all,
> Is there anyway I can create a backup of all the tables in a database,
> without bringing all the users out of the database.
> Paul
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>