On Wed, 5 Nov 2003 14:33:36 +0500, "MAB71"
<b1*********@yahoo.com> wrote:
in <bo*************@ID-31123.news.uni-berlin.de>
There should be a way to copy an access database ( .mdb file ) without
closing connections to it. Unfortunately the FileCopy statement in VB gives
an error if users are connected to the db. But I can copy the file using
windows explorer so there must be a way. WinAPI function or something?
I'm using VB6 and Access 2000
Public Declare Function CopyFile _
Lib "kernel32.dll" _
Alias "CopyFileA" ( _
ByVal lpExistingFileName As String, _
ByVal lpNewFileName As String, _
ByVal bFailIfExists As Long) As Long
I've used this and had each workstation store a backup copy every
20 minutes. I've seen backups of corrupted databases but never a
corrupted backup. YMMV
Consider MSDE if it's at all possible.