Using VB, how can an open mdb file be copied?

[Rickyp]

I have developed a back up system that is opened when my computer is turned on. My Access Back Up program resides on a back up external drive. When the computer is turned on, a Loader.mdb file, placed in the computers Startup folder, opens the Backup.mdb program using the Hidden argument of the shell command. The program is set to back up every 10 minutes using the timer event on the form that contains the programs instructions for backing up. However, if the mdb file that I am trying to back up is open, the FileCopy statement results in error 70 "Permission denied".



Manually, the subject mdb file can be copied by selecting it then using (ctl-c) to copy it, then the folder where the copy is to be placed is opend. Then it can be pasted using ctl-v and windows (xp) copies the mdb file although it is open as the ldb file is open.

Is there anyway VB can be used to copy a locked mdb file?

Thanks for any help you can send my way!

Rickyp

[June7]

I use a vbScript to copy open db, example:
Const OverwriteExisting = TRUE
Set objFSO = CreateObject("Scripting.FileSystemObject")
'following will copy Access file
objFSO.CopyFile "\\servername\path\filename.accdb", "c:\", OverwriteExisting

[Rickyp]

June7

Thanks $1,000,000.00 - Worked like A Dream Come true!

Where & How did you find this information?

Again A Sincere "Thank You"


Rickyp

[June7]

Don't remember where I got it from, just googled until I hit it.