Hi,
I currently use the following code for an Access97 application to backup the frontend and backend files:
'copy database to predefined directory
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFile dbCopyLoc & "\*.mdb", archivePath, True
Set fso = Nothing
However due to the fact that the frontend file doesn't change at all I want to only backup the backend file but when I change the relevant code to:
fso.CopyFile dbCopyLoc & "\BackEnd.mdb", archivePath, True
an error message displays stating "Permision denied" - am I doing something wrong here? if not is there a way to get around this?
Thanks,
Rodney.
I currently use the following code for an Access97 application to backup the frontend and backend files:
'copy database to predefined directory
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFile dbCopyLoc & "\*.mdb", archivePath, True
Set fso = Nothing
However due to the fact that the frontend file doesn't change at all I want to only backup the backend file but when I change the relevant code to:
fso.CopyFile dbCopyLoc & "\BackEnd.mdb", archivePath, True
an error message displays stating "Permision denied" - am I doing something wrong here? if not is there a way to get around this?
Thanks,
Rodney.