Storing PDF files

[pschrader]

Hi !

In MS Access 2007,
is the field type "attachment" appropriate for storing PDF files ?

In MS Access 2003,
how should PDF files be stored ?

Thank you very much for your help.

Peter

 

[Bob Quintal]

Hi !

In MS Access 2007,
is the field type "attachment" appropriate for storing PDF files ?

In MS Access 2003,
how should PDF files be stored ?

Thank you very much for your help.

Peter

..pdf files, and all other types of files should be stored in a
directory. Storing them in hte database itself causes enormous
bloat, regular corruption and extremely slow loading.

What I do is pop up a file requester, get the user to input a file
name, then calculate a new name and copy that file to a specific
subdirectory for that database, then store both file names into a
table in the database. A little code allows opening the file when
you click on the name.

Q