| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > embedding and making PDF files searchable
Using MS Access - embedding and making PDF files searchable
Expert: Richard Rost - 11/2/2009
Question
QUESTION: Beginner level
I have too many magazines with only a few pages of projects of interest. I intend to scan them and would like to store them in a database so I can search them. How do I link a (most likely PDF) file so the content shows in the record? Is there a way to make the text in each PDF itself searchable, or do I have to create at least one field with search words for each record?
Thanks!
Susanne
ANSWER: If you're going to take the time to scan these in, does your scanning software have an OCR feature? If so, can you just scan this data right to text and store that in your database? That would be the BEST solution.
Let me know if you have any other questions or comments.
Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts
Cordially,
Richard Rost
599CD Computer Training
http://www.599cd.com
P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts
I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!
Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=AllExperts
Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts
---------- FOLLOW-UP ----------
QUESTION: yes, as far as I know I have to go through OCR to get a pdf. the thing is, that there will be one or more pictures/ drawings with each article and with a PDF I can keep everything together, text and images.
Currently I have the PDF's as attachments, but then I still have to open each one separately and the good thing about databases is that you can just "page" though a number of records quickly.
Susanne
Answer
My recommendation for any database like this is always to save the scanned images as FILES in a folder that you can LINK to in your database. Access doesn't do well when you scan large images into it. See this post in my blog for my thoughts on the issue:
http://www.599cd.com/blog/display-article.asp?ID=487&key=AllExperts
Let me know if you have any other questions or comments.
Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts
Cordially,
Richard Rost
599CD Computer Training
http://www.599cd.com
P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts
P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.
http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts
I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!
Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=AllExperts
Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts
Add to this Answer Ask a Question
|
|
