Folks,
got another problem. I WAS running a query on a database and kept opening a recordset with a criteria (simple field=data), then closing it, then looping back round and reopening it with new data for the same field.
The data was in an array, and with all the opening and closing of recordsets was running VERY slow. Sometimes up to 3000 entries in the array.
So, i approached it like this....
Select table where field = data1 or field = data2 or field = data3.... etc.
If theres anything over about 40/50 entries to search for i get this....
Microsoft JET Database Engine error '80004005'
Query is too complex.
Im well confused. I feel like im in a no win situation. How can i do the above so it runs quick or correct the "Too complex" issue???
Many thankies in advance
Topic Options
Post Options
Thanks(0)
try the following: