Levenshtein Distance

[TimInAus]

Thanks heaps Banana! Testing shows that the app searches over 120,000 records in a just couple of seconds. Now I just need to work out what parts to pluck out for my app! If I can work that out then problem solved. Thanks again. I'll let you know how I go.

 

[TimInAus]

Hi Banana,

I'm nearly there getting this working in my DB. I have one question for you before I can complete the fuzzy search function.

In the code that you provided there is a file 'TGW6.tmp', I think I've worked out what it is, it's the temp database for the table 'tblPrimarySearch'. I've had no trouble linking it to my DB, but I need to edit it to include the horse ID. That way I can join on it to return the 'full' horse, that is all fields, not just the name. I haven't seen these type of access files before, can you please tell me how to edit it?

Thanks again.

rgds
Tim

 

[Banana]

Hi, TimInAus -

You wouldn't edit the .tmp file (which is actually just a .mdb or maybe .accdb file but probably named with .tmp so it'd be picked up by Windows sweep cleaner) but rather revise the tblPrimarySearchTemplate which is what determine the structure of the temporary file created to aid in the search. It's contained in the database but it's hidden.

If you are using 2007, right-click on the navigation pane and select "Navigation Options" and check "Show hidden objects".

If you are using pre-2007, then it's Tools -> Option and in View tab, check "Show Hidden Object".

You should then revise the tblPrimarySearchTemplate to have the ID added.

Once done that, you have to go over the code where SQL is being executed against the work table, tblPrimarySearch and add the ID where appropriate so you now can then join with other tables.

I hope this makes sense.