Can I attach PDF, Word and Excel files to an Access record?

G

Guest

Can I attach PDF, Word and Excel files to a record in Access? I would like
to be able to add a record to an Access database and attache files created
and related to that record.
 
G

Guest

Hi,
currently it is advised to NOT store files within access. It will cause
bloat and run into problems with the 2GB file size limit.
Instead you would only store the string path to the external file in a text
datatype field and use that at runtime to open these files with the
followhyperlink or shell method.
Access 2007 has a new field data type which is actually made for this
purpose. It can attach files to records and compresses them if they are not
already compressed. If you are interested and don't already have the public
BETA for office 2007 then maybe you can download it and try it out yourself.
Keep in mind that it is still a BETA and should not be used to develope
applications for a production environments.
HTH
Good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top