Simple query giving "system resources exceeded" error

[Billabong]

The query is intended to be run via VBA but fails so I've copied it to the query window and it still gives me the same "system Resources Exceeded" error when run from there too.



I'd appreciate it if someone could tell me what I can do to improve this, I've tried adding and removing quotes and parentheses but I still get the same result.

SELECT auf_nr FROM tmptblTSExtract WHERE ((((tmptblTSExtract.[AUF_NR])=23066488) AND ((tmptblTSExtract.[AUF_POS])=2)) AND ((tmptblTSExtract.[TXT_Line_Code])=0));


Thanks in advance

[JoeM]

How large is your database?
How many records and fields are in this tmptblTSExtract tabke?
Does the table have Primary Keys and indexes?

Have you tried Compacting and Repairing the database?

It may be possible that your database is corrupt. If that is the case, try importing your data table to a new Access database, and try running the query there and see if that makes any difference.

[NTC]

rather than copying in SQL code into a query design - - instead use the manual set up of query design view....

from what I see of your sql code your AND clauses refer to fields that are not included in the select....

[Billabong]

Table is 300K+ records and there's no unique field so I hadn't added a primary key but I have indexed the key fields (Auf_nr and a couple of others) and it seems to be running fine now.

Thanks