Thoughts on Attachment field in Access?
Posted on 2013-05-15
Can someone tell me the pros and cons of using Access's Attachment field type?
I have a table where I'm tracking various header-type information of audit reports (e.g., overall opinion, issuance date, etc.). We keep the reports on a shared drive (on which the database also resides), but I thought attaching the PDFs directly in the database would be nice.
I realize the database would grow that much more with the attachments. Each report is about 120KB, and we issue about 50 reports each calendar - so about 6,000KB of growth annually. I'm wondering about size at which an Access database becomes unstable.
I was hoping someone could provide some input about the size/instability, as well as any other considerations I should make before using an Attachment field.