[AccessD] Scanning documents as attachment

Susan,

  Watch it....the attachment data type and MVF fields are ACE specific; they
won't upsize to SQL.

  It can be a real chore to get the data out again if you move off ACE.

  Best approach I've always found is to store the docs in a directory and
point to the path with an entry in the DB.   You can use the follow
hyperlink to get it to open in the appropriate app.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, September 25, 2014 03:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Scanning documents as attachment

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