Linking files to Access

Adzi

Registered User.
Local time
Today, 22:49
Joined
Jan 13, 2007
Messages
37
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
 
Last edited:
Thank you so much! That's really helped me!

Cheers,
Adam
 

Users who are viewing this thread

Back
Top Bottom