Re: How do I attach a document to an Access database?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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



On Thu, 29 Dec 2005 07:32:02 -0800, "agauthier31"
<agauthier31@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>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?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

.

Quantcast