How do I attach a document to an Access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have an Access database set up with all our clients. My boss
wants me to scan the 50 page contract for each client and insert it in the
form view so he can have easy access to the contract through the database.
Is this possible?
 
It's possible but laborious. I suggest doing it along these lines:

1) Scan each contract and have your OCR software convert it into a PDF
file. Give each file a name that can easily be derived from the primary
key of your Clients table (e.g. if the primary key is a numeric field
ClientID, you could use something like
ClientID Filename
123 Contract_000123.pdf

2) Put all the files in a convenient folder on the network. Let's assume
it's \\SERVER99\Clients\Contract Scans\.

3) In your database, add a button to the form. Put code in the button's
Click event procedure that assembles a string containing the folder and
filename and launches the file, e.g.

Dim strFilespec As String
Const CONTRACTS_FOLDER = "\\SERVER99\Clients\Contract Scans\"

strFileSpec = "Contract_" & Format(Me.ClientID, "000000") & ".pdf"
Application.FollowHyperLink CONTRACTS_FOLDER & strFilespec
 
Back
Top