[AccessD] Automatic backup

[Jim Dettman]

 You can't backup a currently opened DB.

 There's no locks held on a DB so you can do the file copy.   But if another
user is in, or even in your own process if any background tasks are
processing, you might end up with an inconsistent DB.

 Of course you could do that in a small utility DB.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Thursday, March 17, 2016 12:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automatic backup

What is wrong with

Set FSO =CreateObject ("Scripting.FilesystemObject)
On Error Resume Next
Kill strPathtoBackupFile
On Error Goto 0
FSO.GetFile (currentDb.Name).Copy strPathtoBackupFile
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com