Error 70 with FileCopy

[GraeagleBill]

Colin once posted that Error 70 could mean invalid target file name. I don't see anything wrong with either the code statement or the two file names. Have I missed something here?

    If Len(Dir(strBkUpName)) > 0 Then Kill (strBkUpName)
    FileCopy TMSClientDB, strBkUpName

PostError:
    Open TMSClientPath & "AutoLogs.txt" For Append As #1
    Print #1, "TMS DB/Im Backups " & Date & " " & Time()
    Print #1, "Backing up: " & TMSClientDB
    Print #1, "To backup file: " & strBkUpName
    Print #1, "ERROR: " & strOpMsg
    Print #1, "Error Number: " & Err.Number
    Print #1, "Error Description: " & Err.Description
    Print #1, "Now terminating backup process."
    Close #1

And the log:

TMS DB/Im Backups 1/30/2025 4:39:49 PM
Backing up: C:\TMS\TMS-Clients\SCC\SCC Data.mdb
To backup file: E:\My Drive\SCC BkUps\05Thu_SCC_Data.mdb
ERROR: 
Error Number: 70
Error Description: Permission denied
Now terminating backup process.

Same error with 3 other client DB's. All folder names verified by Explorer inspection. Some on local drives and a couple on Google Drive.

[jojowhite]

the error description is suggestive enough, maybe you don't have access right to create a file on that folder.

[GraeagleBill]

Code works fine using FileSystemObject. Still would like to know why FileCopy is failing?

    Set fso = CreateObject("Scripting.FileSystemObject")
    fso.copyfile TMSClientDB, strBkUpName
    'FileCopy TMSClientDB, strBkUpName

[CJ_London]

It fails because TMSClientDB is open. Plenty of links online if you google it

https://learn.microsoft.com/en-us/of...copy-statement

[isladogs]

Colin once posted that Error 70 could mean invalid target file name.

Did I? In what context?
Access error 70 is Permission denied

[GraeagleBill]

Runtime error 70
https://www.access-programmers.co.uk...ror-70.327493/

Your comment about invalid file path.

[GraeagleBill]

It would seem then that I can't copy the BE from code in the FE. How is it that the FSO method doesn't also encounter the Error 70? Also, if I use the DoCmd method to close, that results in an immediate Quit of the current app. I guess I'm a little bit "out on a limb" here?

[Welshgasman]

It would seem then that I can't copy the BE from code in the FE. How is it that the FSO method doesn't also encounter the Error 70? Also, if I use the DoCmd method to close, that results in an immediate Quit of the current app. I guess I'm a little bit "out on a limb" here?

IF you had read that thread, you will see i posted code that would backup the BE or FE from within the FE?
So if that does not work for you, then you do have access permission issues.

[GraeagleBill]

IF you had read that thread

I'd be happy to, but which thread are you referring?

BTW, if I momentarily relink the BE, will that effectively release the locks and thereby allow the copy?

[Welshgasman]

The thread link that you posted?

[CJ_London]

How is it that the FSO method doesn't also encounter the Error 70?

because it is a different method

[Welshgasman]

If I try and copy my db I am in with this
filecopy "f:\users\paul\documents\diabetes.accdb", "f:\temp\tt.accdb"

i too get error 70

From Google https://learn.microsoft.com/en-us/of...copy-statement

Remarks


If you try to use the FileCopy statement on a file that is currently open, an error occurs.

[GraeagleBill]

Ah Yes! I saw the "Compact and Repair" at the head of the thread and moved on thinking "not what I'm trying to do".

[GraeagleBill]

I think I'll settle for the FSO approach to solve the issue. The code is in a general module and by the time it executes the user's interactions have long quiesced to the point where the DB is essentially idle.