Last Reviewed: May 23, 2001
Article: DTS0110
Applies to: dtSearch Desktop versions 5.x, 6.x, 7.x
dtSearch indexes, searches and displays Access, dBase, FoxPro and Paradox files using Microsoft ODBC drivers. If the ODBC drivers are installed, dtSearch will index a database file as a series of records. The name of each record includes the filename of the database, the name of the table, and a record identifier. If instead dtSearch indexes a database as a single text file, you probably do not have the ODBC drivers installed.
Database indexing works best when the ODBC drivers are able to use a primary key to access records in the database. A primary key is a field that is unique for each record and that is designated as a primary key in the database.
The dtSearch Text Retrieval Engine can also index databases using ODBC, but there are other options as well. Click here for more information.
Updated Microsoft ODBC drivers are available from the Microsoft web site. For download information, please see this article in the Microsoft Knowledgebase:
Q239114 ACC2000: Updated
Version of Microsoft Jet 4.0 Available in Download Center
http://support.microsoft.com/support/kb/articles/Q239/1/14.ASP