[AccessD] Scanning documents as attachment

The main problems with storing any sort of BLOBs in the database are

1.  Massive bloat if you are changing the data.
2.  Even if you aren't changing it, you can still quickly hit the 2GB limit on the database size.

 
-- 
Stuart

On 26 Sep 2014 at 2:33, Bill Benson wrote:

> How about ADO streams in a memo field (I guess it is something else in
> AC2013) in lieu of attachments? Reading them in and exporting takes
> some coding skill, but not that complicated. On Sep 25, 2014 6:04 PM,
> "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:
> 
> > I'll say it again.
> >
> > Attachment data types, like Hyperlinks and multivalue fields are the
> > spawn of the devil :-)
> >
> > (I'm sending you a stripped down application with a form that does
> > what you want using conventional data types).
> >
> > --
> > Stuart
> >
> >
> > On 25 Sep 2014 at 15:09, Susan Harkins wrote:
> >
> > > The new Attachment data type makes this so easy that I'm
> > > embarrassed I brought it up...
> > >
> > > Susan H.
> > >
> > > On Thu, Sep 25, 2014 at 1:05 PM, James Button
> > > <jamesbutton at blueyonder.co.uk> wrote:
> > >
> > > > More considerations:
> > > >
> > > > Maybe a commentary field where the user can indicate the source
> > > > of the file -
> > > >
> > > > Frequently documents have codes and signatures, and even the
> > > > originating facility, but do not include the indication of who
> > > > sent it on to you, or even if it is an 'authorised', or
> > > > 'certified' copy.
> > > >
> > > > And
> > > >
> > > > Where is the original filed, what reference/folder/storage
> > > > facility and under who's responsibility, as there will be times
> > > > when electronic copies will not be acceptable.
> > > >
> > > >
> > > > That starts on a whole new table - for the documents received,
> > > > placed in the store, passed on, copied to,  and destroyed etc.
> > > > along with who did the action, and who logged the entry.
> > > >
> > > > Ah! - a whole new administration workload -
> > > > Empire building yea!
> > > >
> > > >
> > > > JimB
> > > >
> > > >
> > > > --
> > > > 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
>