Hi,
in Access versions prior to the new 2007 edition it is normally NOT advised
to store files within the application itself. Access has a bloating problem
which can cause problems with the 2GB filesize limit.
Instead you should store the full string path to the external file in a text
data type field. You can then use the shell() or followhyperlink() method to
open up the file at runtime.
Access 2007 will handle this much nicer with the new attachment data type.
Your other issue of displaying the file itself within Access might be a
little more problematic.
I'm not sure if this is still the case, but adobe had an active x control
you could use within your form.
It was called pdf.ocx, so if you have that then you can go ahead and insert
it and it should work.
If you don't, but you do have acrobat professional (full) installed then you
can use code to programmatically display an instance of Acrobat exchange. I
think the adobe website has code samples for this.
Last but not least...you could use the webbrowser control. Normally Acrobat
viewer comes as a plug in with IE nowadays, so just add the webbrowser active
x control to your form and make it go to your pdf file.
HTH
Good luck
