Stuart McLachlan
stuart at lexacorp.com.pg
Fri Sep 26 08:08:38 CDT 2014
Did you get the sample database I sent you? On 26 Sep 2014 at 7:30, Susan Harkins wrote: > We're on a shared drive that's gainormous. I'm not worried about > space. The only reason she'd change a document would be if you chose > the wrong one in the first place. Each animal comes in with one or two > -- they don't change. She wants to know when she receives them and > then link to them so she can review them quickly instead of physically > finding them in a file cabinet somewhere. > > Guys, the new Attachment field is delightful. You double-click it and > it opens a dialog to let you find and select the file. Once there's a > file, you just click it to open it. I had to do absolutely nothing to > get it to work. For our purposes, that's good enough for me. :) The > ease has got me leaning toward a 10 easy things you didn't know you > could do in Access without a little sweat article or something like > that. :) > > Susan H. > > On Fri, Sep 26, 2014 at 2:49 AM, Stuart McLachlan > <stuart at lexacorp.com.pg> wrote: > > > 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 > > > > > > > > > -- > > 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 >