aqif
Registered User.
- Local time
- Today, 17:07
- Joined
- Jul 9, 2001
- Messages
- 158
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?
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?