MS Access VBA Search Result Performance Improvement

[The_Doc_Man]

Regardless of HOW it is done, it is better done locally on the SQL Server than using the Access FE to process the text, since doing it in the FE implies a LOT of text transfers.