By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,149 Members | 885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,149 IT Pros & Developers. It's quick & easy.

Using Access Attachment function

P: 2
I am considering using attachments (all PDFs) instead of hyperlinking to the documents.

If you use the "Attachments" function, are the attachments actually stored within the database or stored in a directory outside the database and linked. Because of the number of records and attachments, I am concerned about how large the database becomes.
Nov 1 '12 #1
Share this Question
Share on Google+
5 Replies


zmbd
Expert Mod 5K+
P: 5,397
This replaces the older OLE fields.
The file is stored in the database and counts against the 2Gb file sized limitation. More Information on Attachment Fields.
Nov 2 '12 #2

TheSmileyCoder
Expert Mod 100+
P: 2,321
Unless you are dealing with a rather limited database (in terms of size/number of records) I would recommend storing them in a network folder and storing the path instead.

I use a control that allows drag and drop, and when something is dropped onto the field, it triggers a filecopy and starts a record, in which the user can add extra details that can't be read from the filename and properties.

I don't see much benefit of storing items directly inside the database, but there might be cases I haven't considered. Perhaps a small parts database might benefit in efficiency from storing say part pictures internally, but when it comes to documents and pdfs I see no good reason to store them internally.

Just my 2 cents, others might feel differently about the subject.
Nov 2 '12 #3

NeoPa
Expert Mod 15k+
P: 31,494
LJones:
Because of the number of records and attachments, I am concerned about how large the database becomes.
I suggest you store links rather than the attachments if this is your concern. Attachments can certainly cause a database to grow radically in size.
Nov 2 '12 #4

P: 2
I'm interested in your control that allows drag and drop, and when something is dropped onto the field, it triggers a filecopy and starts a record, in which the user can add extra details that can't be read from the filename and properties.
Was this coding that needs to be done, or can you point me to the control/function to accomplish this? If this is coding, can you share?
Nov 5 '12 #5

TheSmileyCoder
Expert Mod 100+
P: 2,321
Ok, I don't have the time today, and I need some time to simplify my current code a bit, cause alot of it would be unrelated and might just confuse matters. I will try to get back to you as soon as I can.
Nov 5 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.