Solved

Thoughts on Attachment field in Access?

Posted on 2013-05-15
1
393 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 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ms access query format every 30 mins 11 37
Access Database 5 39
MS Access Subform Unique Records Issue 14 35
Access Query: Text to Date 10 28
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

685 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