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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top