Is it possible to store .pdf files in an access table

[mls via AccessMonster.com]

I am using ACCESS 2000 and checking to see if I can store .pdf file in the
same table where I store my test results. If so how I can I do that?

If not in ACCESS 2000 is it possible with ACCESS 2007?
Thanks

 

[Dorian]

Why would you want to?
Why not store the PDF file in a folder and just store the hyperlink to the
files location in the database.
Storing other files in an Access database, even if it was possible, would
quickly lead to a huge and inefficient database file.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[johnlute]

I am using ACCESS 2000 and checking to see if I can store .pdf file in the
same table where I store my test results. If so how I can I do that?

If not in ACCESS 2000 is it possible with ACCESS 2007?
Thanks

I don't know if there's a way or not but I would suggest creating a
related "attachments" table where you can store hyperlinks that link
to your PDF files that are stored elsewhere (which is where they
*ought* to be anyway).

 

[Mark Andrews]

Access2007 yes easy just add an attachments field, then on the form you
easily get all the bells and whistles to browse for and add the file. You
can also use code to automatically add or remove attachments in access 2007.
However I agree, LARGE amounts of file storage should always be done outside
of the database (no matter what version of Access). An attachment here or
there in Access2007 is just fine.

Mark
RPT Software
http://www.rptsoftware.com

 

[mls via AccessMonster.com]

Thank you. I have one pdf for each specimen so I think it would be good if I
just store the reference in my table.
can some one give me an example of how I can create the hyperlink?

 

[johnlute]

Add a field to your table and select "Hyperlink" as its data type.

Add a text box control to your form that has this new field as its
record source.

Insert a hyperlink into the control via the toolbar: Insert >
Hyperlink... then browse to your file that you want to link to.

 

[mls via AccessMonster.com]

Thank you. It's very helpful

Add a field to your table and select "Hyperlink" as its data type.

Add a text box control to your form that has this new field as its
record source.

Insert a hyperlink into the control via the toolbar: Insert >
Hyperlink... then browse to your file that you want to link to.

 

[Jack Leach]

just for the record, I personall avoid the hyperlink field, and instead store
just the path of the file. The hyperlink datatype has a lot of extra baggage
that goes along with it, and becomes quite troublesome when you start copying
files around with code.

I would recommend storing a regular text path instead, then you can use the
"IsHyperlink" property of a control to get it to "act" as a hyperlink, or
include the following on the click event:

Application.Hollowhyperlink Me.Controlname


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)