On the web service possibility here's an article in my last months issue of
MSDN though I've not tried any of it as yet.

http://msdn.microsoft.com/msdnmag/is...s/default.aspx

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Fredrik Wahlgren" wrote:
| Dave's suggestion is probably waht you need. If you can create a
connection
| to your SQL server on your local computer, you won't need Citrix. In my
| opinion, using ADO in vba will make it easy and flexible to get data. The
| only problem could be the connection string. You can create an empty text
| file and change the extension to udl if your PC is set to show them. The
| icon will change. When you doubleclick on it, there will be a wizard that
| helps you to build an connection.
|
| You can either use the udl file in your code or change the extension to
txt
| which will reveal the connection string.
|
| /Fredrik