Menu
Does Microsoft Access have Full Text Search?
I know that MySQL and SQL Server have Full Text Search, but I am not too certain on Access.
If Access doesn't have Full Text, what is the best alternative to achieve the same objective of Full Text Search?
Thanks
688
Open the table or form, and then click the field that you want to search. On the Home tab, in the Find group, click Find. The Find and Replace dialog box appears, with the Find tab selected. In the Find What box, type the value for which you want to search.
Full-text search refers to searching some text inside extensive text data stored electronically and returning results that contain some or all of the words from the query. In contrast, traditional search would return exact matches.
A: You can determine if Full-Text Search is installed by querying the FULLTEXTSERVICEPROPERTY like you can see in the following query. If the query returns 1 then Full-Text Search is enabled.
I'm not 100% certain, but the fact that this site from Microsoft doesn't mention Access suggests to me that the answer is "no".
My gut reaction would also be "no". Access wasn't intended to be the ne plus ultra in relational database technology. If it were, there'd be no reason for SQL Server.
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
