Size concern with attaching files.

[chrisfl]

Hi, I've been lurking for a while and finally came up with a question that needs answering. I'm the policy specialist-cum-unexpected database expert for a small nonprofit, so I have to figure this all out as I go along with few resources after not using Access in a couple of years.



I have been putting together a database that has a PDF attached to each record with an Attachment field. The idea is to for it to be self-contained and not reliant on using hyperlinks or whatever. There are about 500 records, and I expect 400-450 or so to have an attached PDF, so the whole file will probably end up being a couple hundred MB. Before I go through the effort of attaching all of these files, is it going to be a problem to attach a few hundred PDFs, either in terms of usability (speed) or other unforeseen issues? I know there's a 2gb total limit, do these extraneous files fall under that?

Thanks!

[June7]

Embedded images will use up file size limit. I don't know if performance (queries, loading forms/reports) will be terribly impacted. Only 500 records will probably not be an issue for size limit or performance.

Get the PDF files compressed to the smallest size that still allows for decent resolution. Can manage this somewhat with Acrobat Pro.

[chrisfl]

Reporting back on this question, I have not noticed any issues with opening since attaching all the files. Thanks again!