attachments

[Dan @BCBS]

I'm looking for some direction on creating attachments.
We receive letters from our members, the letters need to be scanned, then
attached to their record in the database.

I'm not sure were to start! Do I create table to hold the scanned docs?
What format should I use for the docs? etc...

 

[scubadiver]

I read some advice that you shouldn't attach documents directly to the
database because it would get too large (2GB is the maximum).

What you can do is save links to a text box by using a button to open the
windows directory and using a second button to open the file.

This is what I used:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=SetHyperlink.mdb

It may help

 

[John W. Vinson]

I'm looking for some direction on creating attachments.
We receive letters from our members, the letters need to be scanned, then
attached to their record in the database.

I'm not sure were to start! Do I create table to hold the scanned docs?
What format should I use for the docs? etc...

I'd strongly suggest NOT incorporating the documents themselves into the
database - it will cause the database to bloat very rapidly.

Instead use either a Text field or a Hyperlink field, containing the disk
drive, folder path, and filename of the document. You'll need some disk
storage convention, but you could then have

E:/MemberFiles/Documents/K31415.doc

stored in a field in your table, and be able to open Word (or Excel, or an
image viewer, or whatever) to view the document.

John W. Vinson [MVP]