Solved FSO.CopyFile

[Eljefegeneo]

I am using the following to copy a backend from one folder to another. My code is:

Call FSO.CopyFile(fSource, fDest, True)

I copied the backend but is asks if I want to replace the existing file. A search of the forum is that possibly I don't have the correct reference ticked off. But I am using late binding. Access 2010

So, either what am I doing wrong or should I just insert a Kill command to delete the old file before I copy it?

 

[Eljefegeneo]

sorry should have included this also:

Dim FSO As Object
Dim fSource As String, fDest As String
Set FSO = VBA.CreateObject("Scripting.FileSystemObject")

 

[theDBguy]

Yes, use Dir() to see if the file exist and then Kill it.

 

[moke123]

Take a look here and see if it helps http://accessmvp.com/thedbguy/codes.php?title=backup

edit: was looking for the link when DBG's post appeared.

 

[arnelgp]

strange behavior, since you already put True (force copy) as the third parameter.
if it exists and not in used, it will be overwritten.
if in used, there won't be any error msg, but it will not get overwritten.

 

[Isaac]

Strange behavior, indeed

 

[Eljefegeneo]

I "fixed" it by deleting the old file first and then adding it. The really strange thing is that I use the same code in a different Private sub for another backup of a file and it works perfectly. Fixed is fixed.

 

[theDBguy]

I "fixed" it by deleting the old file first and then adding it. The really strange thing is that I use the same code in a different Private sub for another backup of a file and it works perfectly. Fixed is fixed.

Hi. Congratulations! Good luck with your project.