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