Solved

Thoughts on Attachment field in Access?

Posted on 2013-05-15
1
401 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 58

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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

728 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