Solved

Access 2003: Match Function

Posted on 2008-10-05
5
221 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 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
>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 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
> 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
Comment Utility
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 142

Accepted Solution

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now