attachments in access

[Homegrownandy]

I've just discovered today by accident that we can use attachments within access for a record. I'm just wondering before I get too far into this how to manage attachments for a record.



For example: Lets say I have a variety of attachments associated with one order. some of them are invoices, some of them are certificates (whatever they may be).

Am I able to show on a form ONLY the invoices. even if they are stored on the same record as any other document?

If I'm not able to its no problem I can separate them through other tables associated with that record. I'm just curious if anyone uses this feature and how.

Any thoughts appreciated.

[CQCDave]

The only problem with attachments in access is the size of the attachments. They can grow the database and you end up reaching it's max size rather quickly. I store any attachments on a server and hyperlink to the documents not storing them in access.

[Homegrownandy]

That's what I'm currently doing. I will continue to do so, I just found it interesting.

[orange]

Andy,
Is there still a question? I think Dave has given the reason why attachment fields may not be an optimal strategy for storing "attachments" with Access.

[Homegrownandy]

I am still interested yes. There's no problem to solve just curiosity if anyone has used this feature.