Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Searching Acess databases

  Asked By: Rozi    Date: Mar 05    Category: Sharepoint    Views: 735

I wanted know whether SPPS search can search MSAccess databases. If so how?



3 Answers Found

Answer #1    Answered By: Gaurav Ghosh     Answered On: Mar 05

Sharepoint can't directly search  any databases. The reason for that is,
that structured data (like Access, MS-SQL etc.) doesn't make any sense
unless showed in a context. What you'll have to do is to create an
web-interface that defines the context - forms, reports etc. that displays
the data - and then crawl those with the web-site protocol handler.

Answer #2    Answered By: Katelynn Donovan     Answered On: Mar 05

But these reports will be dynamic right? Can you elaborate on web-site
protocol handler?

Answer #3    Answered By: Geraldine Slater     Answered On: Mar 05

>But these reports will be dynamic right?

Yep, You'll have to make then in .asp or something alike.
E.g. if you have a catalog of products. One .asp page lists all the
products and provide a link to another .asp page for each of the products.
The second .asp page is called with a parameter, like '?id=123'.
Set up a content source that points to the first catalog .asp page and it
will index all the sebsequent products, thus make them searchable.

Hope this will help...

>Can you elaborate on web-site protocol handler?

Sorry, I just meant a content source that crawls websites.

Didn't find what you were looking for? Find more on Searching Acess databases Or get search suggestion and latest updates.