Recent content by TimInAus

Thanks Banana. I don't think the query idea will work, I've tried something similar and access spits it when you try to save. I've found a way to create databases/tables and link them through c# using ADOX and Jet. I'll move the vba code to c# as the reason I had it in Access was so I could...

Hi Banana, This is acually for the fuzzy search function that you helped me out with not too long ago. The vba code; 1. creates a temp database 2. creates a table in the database 3. links the table created in step 2 to the main database 4. runs a query and inserts the results into the table...

Thanks guys, I realise I can't access the vba from outside the database. But I can access stored queries. So if I can call the function from the stored query and have it return the results to the stored query then I'm in business. I just need to know if I can have a stored query along the...

not a fuzzy search, that is the function that I need to select from

Hi Guys, I'm hoping someone can put me in the right direction. I have a C# app that uses access as the DB. I have some vba code that will create a table and populate it with some data. I now need a way to call the function and select from the new table externally. I'm still relativly new to...

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...

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.

Thanks for you advice everyone. Looks like I'll have to go with a different approach. It's a shame that there isn't a public accessable solution for these types of searches.

Wow, thanks for all the responses guys! I'll try to answer your questions and give more info. I am re-writing an application that records details about racehorses. The original version was written 18 years ago in early C++ using Access as the DB, I’m re-writing it using C# and Access for the...

Hi All, I hoping someone can help me with an issue I'm having I'm trying to design a fuzzy search feature for a C# application that uses MS Access as the DB. I am searching on a list of horse names, there are 130,000 horse records in the database. I've tried lots of different algorithms...