how to incorporate pdf files in access

[Guest]

I need to create an access database which will catalog scientific documents saved as pdf files. Is there a way to link these files and also search them by keywords in access. The form would then display all the documents found that match the keyword.
Thanks, Ann

 

[Adrian Jansen]

I dont think you can search *within* a PDF file from Access. But you can
create a table to hold the path\filename to the document, and another table
to hold keywords that you create, applicable to the documents. Then a
junction table with references to both tables will allow you to pull
documents associated with the keywords.

tblDocuments
DocID - primary key
Filepath - text

tblKeywords
KeyID - primary key
Keyword - text

tblDocRef
DocID - foreign key to tblDocuments
KeyID - FK to tblKeywords



--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

I need to create an access database which will catalog scientific

documents saved as pdf files. Is there a way to link these files and also
search them by keywords in access. The form would then display all the
documents found that match the keyword.

 

[Immanuel Sibero]

As the previous poster suggests, you can create tables to handle this.

How do you implement keywords? Do you assign keywords to the pdf documents
using words that are in the documents themselves? So as to allow a text
search? If so, depending on the size of your project, it might be worth it
to get the Acrobat API library. In Access VBA, using the library you can
pick up all the verbage (texts) from the pdf documents then write them to
Access. Basically this will automate building your tblKeywords.

Immanuel Sibero

I need to create an access database which will catalog scientific

documents saved as pdf files. Is there a way to link these files and also
search them by keywords in access. The form would then display all the
documents found that match the keyword.