Many thanks namliam, excellent the code worked.
However, I'm now trying to copy a file (selected by the user) to the database directory.
I have a directory named "testDFirectory" in the root directory where the database is located which I want to copy the file over to.
However, when I run the code (see below) i get the following error message "path/File access error", I'm not sure what I'm doing wrong.
Also, when I copy the file to the destination directory I would like to keep the name of the file the same although appended with the date and time.
Sorry, I have only basic knowledge of VB.
Dim currDir As String
currDir = Left(CurrentDb.Name, InStrRev(CurrentDb.Name, "\"))
...
FileCopy myFileToCopyPath, currDir & "\testDirectory"