How To Copy Locked Access Database

[sateeshpatil]

Hello.....

While I am trying to take back up,its giving error like permission access denied cz of .ldb ,Please tell me how can i copy locked access database......

Regards,
Sateesh R Patil

[QVeen72]

Hi,

Add this Reference to your project :
Microsoft Scripting RunTime
and Check this code:

[code=vb]
Dim FSO As New FileSystemObjec t
FSO.CopyFile "C:\MyFolder\My DB.mdb", "C:\BackUp\MyDb .mdb", True
MsgBox "Back Up Completed"
Set FSO = Nothing
[/code]

3rd argument true will Overwrite existing db (if found)

REgards
Veena