What is slow? It may be the way you're coding. Did you mean to pass a
variable to your SQL? Absolutely.

--

Regards,

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

"Goofy" wrote:
| 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.