Results 1 to 2 of 2
  1. #1
    adis44 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    1

    Create a search engine for a collection of PDF files using Access 2010

    Hello,
    Any tips would be appreciated. I am fairly new to Access and need some help. I have a collection of PDF documents (about 9000 of them) saved and separated alphabetically in a master folder.
    I.E. Main folder is "PDF Documents". In this folder there are 26 folders, one for each letter A-Z. Folder "A" contains all PDF's that start with the letter A and so on....

    Can i create a search engine in Access to scan this folder and find a particular document by file name. For example search and pull up file apple.pdf located in folder A.

    If someone can give me any tips on how to achieve this. Thanks!!

  2. #2
    Dan is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    15
    The whole point of a search engine is to index content for fast retrieval. Store the path to file in your database and occasionally comb the folder structure for new files. If you cannot find the file in your table lookup and open it then you can FINDFILE by traversing your folder structure starting in the alphabetized one and so on; a user could misfile a PDF? Remember Google is your friend, plenty of code to adapt for this out there.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-11-2011, 01:52 PM
  2. Access 2010 - search query not working
    By beetgirl in forum Access
    Replies: 6
    Last Post: 07-12-2011, 09:56 PM
  3. Search engine result database suggestions
    By PIHA520 in forum Access
    Replies: 0
    Last Post: 05-29-2011, 05:44 PM
  4. Replies: 1
    Last Post: 04-01-2011, 01:28 PM
  5. Replies: 1
    Last Post: 02-21-2011, 09:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums