FileCopy Question *SOLVED*

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.

Code:

---

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"

---

Quote:

---

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

---

Yes!

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

Thanks. It now works using the below.

Code:

---

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

---