Copy Database Code Error

[Tomfernandez1]

Hello,



I am trying to run a code for copying my database to a different location, but in running the code, I get the following an error, which when "debuged", has this line highlighted in yellow:

oFSO.CopyFile sSourcePath & sSourceFile, sBackupPath & sBackupFile, True

Any idea what the problem is? Here is the entire code:

Public Function BackupCopy()

'This function will allow you to copy a db that is open,

'You must set a reference to the 'Microsoft Scripting Runtime' for the CopyFile piece to work!

Dim OFSO As FileSystemObject

Dim sSourcePath As String
Dim sSourceFile As String
Dim sBackupPath As String
Dim sBackupFile As String

sSourcePath = "C:\Documents and Settings\tommyf\My Documents\DBackup\"
sSourceFile = "VANPOOL RIDERSHIP 1008.mdb"
sBackupPath = "C:\Documents and Settings\tommyf\My Documents\DBackup\backup\"
sBackupFile = "BackupDB_" & Format(Date, "mmddyyyy") & "_" & Format(Time, "hhmmss") & ".mdb"

Set OFSO = CreateObject("Scripting.FileSystemObject")
OFSO.CopyFile sSourcePath & sSourceFile, sBackupPath & sBackupFile, True
Set OFSO = Nothing


Beep
MsgBox "Backup was successful and saved @ " & Chr(13) & Chr(13) & sBackupPath & Chr(13) & Chr(13) & "The backup file name is " & Chr(13) & Chr(13) & sBackupFile, vbInformation, "Backup Completed"

End Function


Thanks, in advance, for your help!

Tommy

[pbaldy]

What's the error? It might not like the spaces in the file name.

[Tomfernandez1]

Hi Paul,

The error reads "Run time error 76 - path not found"

I rechecked the paths and placed underscores to fill spaces in the filename, but the error message persists.

Any ideas?

Tommy

[pbaldy]

I tested your code and it worked fine (Win XP Pro, Access 2000). I tried paths with and without spaces, so I don't think that's the issue. The error implies there's a problem with the path, though it wouldn't be the first time an error message was misleading. You're sure the path is exactly correct?

[Tomfernandez1]

I am sure the path is correct. I am using 2003 version.
Tommy

[Tomfernandez1]

I think the problem is the code was written to run the same database it is written on. using a different database (different source path/file), the code and it worked fine.

This changes the problem to being unable to run this code in a database as the source path. Is there a method for resolving this...?