I tried that Remi but am now getting this error message:

Object required: 'adUseClient'

I feel as though the adUseClient command must go after I've...

OK guys, thanks for the quick replies, I've tried setting the CursorLocation as suggested but am now getting this error.

Operation is not allowed when the object is open.

My code now...

Sorry to be a pain in the derriere, but maybe I should have mentioned that I'm still pretty new to SQL

I think I understand...

Well, after much trial and error, I finally achieved what I wanted to do, which was use ASP to connect to an SQL database, extract...

Brilliant!

As they say, it's easy when you know how, it's just the 'knowing how' bit that I need to work on.

Jim & Mike,...

Thanks Mike, that worked absolutely perfectly.

I would now like to ask a follow-on question, which I hope is okay to include on this...

I forgot to say thank you......

THANK YOU

Oh my goodness!!!!!

I can't believe that all I had to do was click on the drop down menu box and change the default MASTER db name to the one that...