FileCopy Question *SOLVED*

[lintz]

I have an option for the user to make a backup of the database into the directory C:\Backup. This is fine. My question is when I want to copy the backed up database into the application folder do I have to specify the full directory path or can I use something like this "App.Path & "\database.mdb"?

Below is the current code I'm using.

Private Sub mmuBackupsRestore_Click()
Const Directory = "C:\Backup"
Const File = "database.mdb"
Dim FSO As Object
FileCopy "C:\Backup\database.mdb", "C:\Program Files\KidsSpace\database.mdb"

[Armbruster]

Originally posted by lintz
can I use something like this "App.Path & "\database.mdb"?

Yes!

[radum]

note that if you only do a FileCopy, you dont need the file system object.

[lintz]

Thanks. It now works using the below.

FileCopy "C:\Backup\database.mdb", App.Path & "\database.mdb"