Quote Originally Posted by XLGibbs
Strange. The line as I provided is exactly as shown from MSDN as well.
Oh Boy! MSDN... weren't they a source for the existence of WMD's?

YOu might have to reference the "master" db to change the setting or something.
Tried that. No Luck

I am having a similar issue with remote query timeouts. the settings are all at 0 (For infinite), but I still get a timeout/server resource error. MSDN is less than helpful as expected on this issue too. And each of the linked servers being used has essentially unlimited resources for what I need to do.
I set connection.CommandTimeOut =0. It has allowed me to SELECT INTO [sql server tables from Access tables] 500-600 meg per .execute() no problems. BTW: I attached how the Remote Queries appear in the Surface Area Configuration Features tool - why the error object reports it doesn't exist or is advanced is beyond me. Stan