Hi

I’m trying to find out what the most efficient method of finding data in a table.

My database reads two text files containing 15,000 records each. The first file is read and stored in the table using the Addnew command and is pretty quick, the second file is an update file and needs to match the existing records in the table.

My existing code is “Select * from tablename where code = “ & secondfilecode

As this has to search through 15,000 records it is quite slow, is there a better way to do it?

Thanks
Jane

I had a look on the net to see what i could find, and i found a basic search for a form using VB code, and i managed to get it working. There were some bits which i found confusing, and didn't understand 100%, but i got it working. If you take a look on this site, in the form section, you will find one for adding a simple search to your form. There is also loads of other useful code on the site to use. Its all free. The form search link is :
http://www.microsoft-accesssolutions.co.uk/text_search.htm

Hope that is any help. let me know

Hi

Thanks for the effort, but not really what I'm looking for.

I'm using a ADO recordset with VB.

Jane

If you are using ADO then maybe the problem is there. You may consider the organization of the 2nd database.