[AccessD] Odd Attachment field types in query

 The real down side to the attachment type is that it's strictly ACE that
supports it.  Becomes a real chore when you want to move the data anywhere
else (like SQL Server).

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, October 30, 2014 08:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Odd Attachment field types in query

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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com