Access 2003: Match Function

SELECT MATCH(table1) AGAINST (table2) as Relevance FROM table

as i understood .. match is not available in access/sql. Is it possible to get this function in Access 2003?
i have Levenshtein in a vba function working in access.. but i want to compare it to the match function from mysql
Amien90Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
the problem is still the same... MATCH in mysql is part of the sql language, compiled into mysql engine. if you create a vba function, it will be an "outside" function, not being able to use some kind of index (which is the main goal of the full-text index...)
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>as i understood .. match is not available in access/sql
correct.

you will have to use some "real" database engine like MySQL, MS SQL Server, Oracle etc which do support full-text indexing.

are you aware that you could use ms access as front-end, and keep the database in MySQL, and with pass-through queries use the MATCH() function?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> i  have Levenshtein in a vba function working in access
note that such a function cannot use any index on the tables, so will do result in a full table read ... not really coool...
0
 
Amien90Author Commented:
thanks for the response

the match function of mysql is available right? (open source). i could rewrite that code to vb.. perhaps anyone did this allready?
0
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.

All Courses

From novice to tech pro — start learning today.