Thanks for the tip, it worked fine.

One other question, then. How and why do you use SYSNAME in sprocs?

Thanks

Brian, Steve,

Thaks for the excelent advice, time ot get off my duff and get going.

RB

thaks to all for your help, afnter I deleted all the linked servers, then recreated them.

THEN rebooted the server, the problem was fixed. Thanks again for all your help

I reregistered sqloledb, now am getting a new error with queries to link servers (selects only)

---------------------------------------------

ODBC: Msg 0, Level 19, State 1

SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL...

Thanks much for the tip I'll try it later today.

RB

Thanks much for all your help.

Richard

Thanks, Brian,

What do you mean by pure Tranact SQL?. What I really would like to do is execure the package from a Access project. tought I could do so by...