Access 2003 full text index

Posted on 2007-03-20
Medium Priority
Last Modified: 2010-03-20
Hi Experts,

Anybody know if Access 2003 has a way of creating a full text index that can be queried against?  Not the field like '%blah%'  syntax but a ranking type system that you see in MS SQL Server, MySQL, or PostgreSQL.

If it does have a full text index system, can you point me at a how to or some documentation about it?

Question by:upandrun3
1 Comment

Accepted Solution

KelvinY earned 1000 total points
ID: 18758124
Hi Pete

As far as I know full-text search is a new feature in Access 2007 and I don't expect that there are any plans to retrofit it to Access 2003.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question