Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Thoughts on Attachment field in Access?

Posted on 2013-05-15
1
Medium Priority
?
419 Views
Last Modified: 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.
0
Comment
Question by:songwritingcpa
1 Comment
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39167917
<<I'm wondering about size at which an Access database becomes unstable.>>

 Size is not an issue.   Access DB's can go up to 4GB in size and will work fine at that size.

<<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. >>

  Attachment fields are easy to use, but most developers don't use them because they are only available in Access.   If you upsize to SQL Server, you need to extract all the data and handle them a different way, such as keeping a pointer to the file in a table, and then loading the document as needed within the app.

Jim.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question