Connecting Tech Pros Worldwide Forums | Help | Site Map

Opening other file formats in Access - pdf's

anukagni's Avatar
Member
 
Join Date: Nov 2006
Location: India
Posts: 53
#1: Dec 13 '06
Hi all,

Iam Having some Articles and Juronals of my Institute which are all in PDF format and I want to retrive this thing using Access ..

I ill explain assume that i am having set of pdf file which is having unique name with it and i want to creat an DB in which i want to feed this names and giving an hyper link to the pdf file. Now i want to retrive this pdf file by searching using the name which i entered it this possible please give me an solution. If ur not able to understand reply me..

anukagni

msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#2: Dec 13 '06

re: Opening other file formats in Access - pdf's


Quote:

Originally Posted by anukagni

Hi all,

Iam Having some Articles and Juronals of my Institute which are all in PDF format and I want to retrive this thing using Access ..

I ill explain assume that i am having set of pdf file which is having unique name with it and i want to creat an DB in which i want to feed this names and giving an hyper link to the pdf file. Now i want to retrive this pdf file by searching using the name which i entered it this possible please give me an solution. If ur not able to understand reply me..

anukagni

The easiest way may be to create a table with the full path to the pdf files in one column and make it a hyperlink data type and the file name in another column of text type.

You could then create a form with a combo box set to the table with the hyperlink column hidden and the file name column displayed.

When user selects file name then file should open.

Mary
anukagni's Avatar
Member
 
Join Date: Nov 2006
Location: India
Posts: 53
#3: Dec 15 '06

re: Opening other file formats in Access - pdf's


thanks ,

I think of it but i am afraid of speed & hyperlinks ..if iam using this in intranet weather the speed of the database get lower or the hyperlink will work properly..

anukagni
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,730
#4: Dec 15 '06

re: Opening other file formats in Access - pdf's


Quote:

Originally Posted by anukagni

thanks ,

I think of it but i am afraid of speed & hyperlinks ..if iam using this in intranet weather the speed of the database get lower or the hyperlink will work properly..

anukagni

This is something you'll have to try out for yourself.
There are too many unknowns here for someone to direct you on this.
I certainly don't know of any better / more efficient way myself.
anukagni's Avatar
Member
 
Join Date: Nov 2006
Location: India
Posts: 53
#5: Dec 18 '06

re: Opening other file formats in Access - pdf's


okey,

I ill... :)
Reply