Question Can Access do it for me?

[Shuggie]

Hi

Excuse me asking a very basic question but I'm not sure of the capabilities of Access. I'm wanting to create a way of searching through and displaying a large number of pdfs. These will be of different lengths and most will have images embedded in them. Each pdf will be categorised using a variety of fields to enable fairly sophisticated searches. I then want to link this database to a Joomla CMS website.

Does it all look do-able?

Shuggie

 

[DJkarl]

Hi

Excuse me asking a very basic question but I'm not sure of the capabilities of Access. I'm wanting to create a way of searching through and displaying a large number of pdfs. These will be of different lengths and most will have images embedded in them. Each pdf will be categorised using a variety of fields to enable fairly sophisticated searches. I then want to link this database to a Joomla CMS website.

Does it all look do-able?

Shuggie

When you say searching through a PDF do you mean you are creating database fields that contain data about the PDF, or you actually want Access to search through the contents of the PDF file?

 

[Shuggie]

I don't want Access to look inside the pdf. I just want to be able to search through the fields I've used to describe the pdfs and pick out the ones that satisfy the query. I really just want to know whether it's possible to do this with pdfs.

Shuggie

 

[spikepl]

You can search and extract from an Access db all the info that you put in it.

 

[speakers_86]

You can eve fill in a pdf using records from a table if you place the controls very carefully on the report.

edit- and use the pdf as an unbound report image. Reports have a property that is something like page background that can be linked to the pdf.

 

[DJkarl]

spikepl is correct, you can search/extract whatever you put into the database. If you want to store the actual PDF files in the database as objects in the table I would caution against that unless they are very small files, otherwise you will run out of space quickly.

 

[Shuggie]

Thanks very much - very helpful
Shuggie