Storing pdf file inside ACCESS

[thread]

Hi all,
does anyone know if there is an option to store a pdf file inside of
ACCESS or open it as an object inside ACCESS form?
i'm searching for examples

 

[Guest]

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

 

[thread]

Hi freakzeud
thank you very much for your help
for now i can only open pdf file as a link tunnel from access but still
i want to find a solution that i can open pdf file from the access
himself.
the storing is something that i put an eye on as well as it will be
very impressive to bring a pdf file from within the access but the
problem is that the access in not accepting the format of the pdf even
converting the file to excel will not help with the format,
regarding the size of the ACCESS i already found some solution with the
compaq and repair automation so that is not a problem

if i will make the access to be more dynamic for pdfs it will be very
usefull

freakazeud ëúá:

 

[thread]

Hi Freakzeud
I found a way to store files in the ACCES,its called OLE object for the
pdf files its still a tunnel but i think i almost reach what i want
thread כתב:

 

[Clint Covington \(MS\)]

The new attachments feature in Access 2007 makes this really easy. Here is a
blog post on the subject.

http://blogs.msdn.com/access/archive/2006/04/25/583584.aspx

Clint Covington