Actually Dave, it did work, it was me that was in error. However, it does
not really seem to be much faster, but then we are talking vba here so that
is probably the bottleneck.

I know that on ODBC, you cant use named parameters, but are you able to do
this using OLEDB ?

Cheers for your help.




"Dave Patrick" wrote in message
...
That doesn't help much. Can you post your code, exact text of error, and
on
which line?

When you;
Tools|References was this available? 'Microsoft ActiveX Data Objects 2.x
Library'
Can you see them in Control Panel|Admin Tools|Data Sources ?

--

Regards,

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

"Goofy" wrote:
| Thanks for your reply Dave, I did try the "provider=SQLOLEDB before and
it
| still came up with an ODBC message telling me the driver was not found.