Retrieving PDF's Efficiently

[tcheck]

I created an Access 2007 database that I thought I was linking the files but it actually imports the PDF's into an Attachment field in Access. I have imported about 130 pdf's thus far and the table (which only has 7 fields) is already 14 meg. Do most users attach PDF's or do they link them?

[orange]

Most will save text, jpg, pdf etc in a file system and simply point to the file.
Access is known "to bloat" when these are made an integral part of a database.

I don't have acc2007 and have no experience with attachment type fields.

[tcheck]

Thanks for the reply.
Does anyone out there do this on a regular bases and can point me in the most efficient method. I will also want to upsize the backend database to SQL 2008 at some point.

[orange]

There is a sample database identified here
http://www.access-programmers.co.uk/...d.php?t=131703

The author stores the pdf name and file location in a table.
He then has a form allowing the user to select a pdf by name and load it from a file folder.

Note that you can test the set up, but you'll have to identify your file location specifically.