Solved

Access 2003: Match Function

Posted on 2008-10-05
5
229 Views
Last Modified: 2013-11-05
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
0
Comment
Question by:Amien90
  • 3
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22645592
>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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22645599
> 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
 

Author Comment

by:Amien90
ID: 22647627
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22647635
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

735 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