Hi Flo

Tried using OLEDB but this time the error is

[DBNETLIB]ConnectionWrite (send()) General Network Error Check your network documentation

Again it is intermittient at times it cant authenticate...

Hi Florian

Thanks for reply -Im not using VB NET or VB6 - just VBA. I am opening connection

using ADODB. All the latest drivers are installed. The connection...