Linking files to Access (1 Viewer)

Hi Guys,

I have been asked by my employers to create a document retention system.

1. They recieved two documents from the customer which are scanned in as two separate PDF files. The PDF files are stored on the scanner units memory.
2. The scanned documents are accessed from a web interface.
3. The PDF will be downloaded and then saved to a folder.
4. The user will then link the file in the database by entering the file path into a field. (how?)
5. VBA code will be executed to rename the file, move the file from the original path and dump it in a central folder.
6. A shellexecute script will be used to open the files from within access. (this is covered)

So how do I go about llinking the files? I have never used access as a 'document server' before. Is there a way to have a file upload window where the user can navigate to the file? I can do the renaming bit all fine, just need to actually get the files path!!

Any help would be greatly apreciated.

Cheers,
Adam

Check out my old Browse [Find a directory or file] sample to see how to get the file and path info from a users selection.

Thank you so much! That's really helped me!

Cheers,
Adam