I'll give that a whirl I'll also check to see if we have the latest office packs

I have no idea I have been tearing my hair out all day on this. the hosting company claim its because certain objects aren't on the server, but I have...

I have tried that and while you have the app open it works if you close it and reopen it it defaults back to 10k, any other ideas?

where can you set the 10k limit for the whole app? at the moment i am only doing it form by form

Cheers Martin works a treat now

Basically it returns the same data as if you run the first SP on its own, this is what each of the SP's consists of:

The main SP called sp_DoSomeWork

ALTER...

Hi thanks for the quick reply

I have tried the above, but when I run USP_DOSOMEWORK it only runs the first step any ideas?

Cheers Morpheus

But I didn't explain myself well enough, what I need to do is search on a user entered criteria. So for example a user types in a town name...

Thanks guys as soon as I managed to change to the Auth to SQL voila!! working a treat thanks again