[AccessD] Hourly Backups Of Access Data

Paul,
I just looked at my backup routine but it won't work for you, uses
CompactDatabase. Guess I should create a new one.

(Thinking out loud here) how about:
Create a routine to export all of the tables and data to a new DB. That
shouldn't affect any of the users.

Create a seperate routine that clears the tables and imports/appends it all
back in just in case you need to restore the data. If that case arises it
would probably mean the users can't get in anyway - otherwise you would have
to kick them all out.

This would alleviate worrying about relationships, etc.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> 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
>
>