Hi Kevin,

to my low english:
>going to pull out around 5 to 6 records

means the result is 5 to 6 records (IOW _Tally=)?

How many records are used to create those records? SELECT SQL generates temporary cursors within the select. If temp space is low it may fail. Remeber that WHERE / ORDER / GROUP and the like will happen after all joins are done.

HTH
Agnes
>Hi
>
>One of our users has just recieved this message, this is the first time it's happened.
>
>All the program is doing, is a SQL SELECT and then running out of memory, the actual query is only going to pull out around 5 to 6 records, it doesn't error all the time, it is intermittent, the SQL is run from a timer every 1 minute, it is selecting into an array.
>
>Any ideas? I'm pretty sure it's not actually "out of memory"!
>
>Thanks
>Kev