If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
attachments
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... |
#2
|
|||
|
|||
attachments
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/d...tHyperlink.mdb It may help -- www.ae911truth.org "Dan @BCBS" wrote: 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... |
#3
|
|||
|
|||
attachments
On Wed, 8 Aug 2007 05:32:01 -0700, Dan @BCBS
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|