Hi
I am using Access 97 and I am trying to make a copy of my database which is opened by the user. I am uaing follwing syntax
Dim SrcFile, DestFile as String
SrcFile = CurrDB.Name
DestFile = "C:\BackDatabase.mdb"
MsgBox SrcFile & vbCrLf & DestFile
FileCopy SrcFile, DestFile
For some reason it is not working for the current database maybe because its opened and locked. When I try to copy another file it gives no problem.
Any syggestions?
Cheers!
ÙÇãá
I am using Access 97 and I am trying to make a copy of my database which is opened by the user. I am uaing follwing syntax
Dim SrcFile, DestFile as String
SrcFile = CurrDB.Name
DestFile = "C:\BackDatabase.mdb"
MsgBox SrcFile & vbCrLf & DestFile
FileCopy SrcFile, DestFile
For some reason it is not working for the current database maybe because its opened and locked. When I try to copy another file it gives no problem.
Any syggestions?
Cheers!
ÙÇãá