[AccessD] Odd Attachment field types in query

Stuart McLachlan stuart at lexacorp.com.pg
Thu Oct 30 19:44:53 CDT 2014


They aren't links.  If they are stored in Attachment fields, they are stored as BLOBs inside the 
database and take up a lot of room.

Add a few multi MB scanned attachments and see what it does to the size of your .accdb file 
:(



On 30 Oct 2014 at 18:16, Susan Harkins wrote:

> The attachments will be links to scanned files. The Attachment field
> type does everything -- click it and it walks you through the process
> of finding and linking the file. Click it again and it opens the file
> you just saved.
> 
> Susan H.
> 
> On Thu, Oct 30, 2014 at 4:02 PM, Arthur Fuller
> <fuller.artful at gmail.com> wrote:
> 
> > Your all-too-abbreviate reply insufficiently describes your problem,
> > Susan. Do you want to saeseeve the attachments as separate files or
> > simply junk them. I have the answer to bothre questions, but require
> > more info about your intent before I can help.
> >
> > Arthur
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list