First and foremost, the db is split into front and back ends, and every user has their own front end? By your post I would guess so. The answer is to store the files in folders and store the paths in the back end. How you do this is a much larger discussion, because it's as simple as manually storing the files, having a form to paste in the path in a table short text field and using Application.FollowHyperlink to open the file
OR
using Access to choose the folder, store the file, retrieve it, email it when needed, record routing, date stamp approvals, etc.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.