[AccessD] Odd Attachment field types in query

James Button jamesbutton at blueyonder.co.uk
Fri Oct 31 11:39:45 CDT 2014


Consider -
It does not take that many picture scans of files to take up 2GB
So if they are to be BLOB's it maybe better to have the attachments in a
separate linked database

And inside the database the files are not immediately accessible without the
databased facility being 'open'  so maybe, if you want to be able to use bulk
processing such as Irfanview Thumbnails to view all pictures  it may be better
to have the files held in an associated folder (protected from
deletion/replacement) with hyperlinks to them

That does mean you have to make sure you save/backup/restore the file folder and
contents with the database.

JimB 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, October 31, 2014 12:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Odd Attachment field types in query

Yeah, I know, but that's what the boss wants. She won't use it often.

Susan H.

On Thu, Oct 30, 2014 at 8:44 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

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