[AccessD] Scanning documents as attachment

Hi Arthur

That was exactly what I tried to suggest, though leaving out the details. 
I failed ... time for a Friday's beer.

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Arthur Fuller
Sendt: 26. september 2014 14:49
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Scanning documents as attachment

Susan,

Gustav  has a good idea, although not quite on the head, since the attachment fields are part of the table itself. But one thing you could do is create a second table containing only an FK pointing to the original table, plus as many attachment fields as you think you might need. Then you could move only that table to a new database and modify your form to join the main table to its attachments. Best of both worlds.

Incidentally, Helen Fedemma has some good code for working with attachments, should you need it.

Arthur

On Fri, Sep 26, 2014 at 7:39 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Susan
>
> Well, at least I think you should create and link to a separate accdb 
> for the attachment storage. This way many and/or large documents won't 
> ever gobble up your main data.
>
> /gustav