Hello!

I wonder if anyone's seen this one befo the environment is Office
2000 running on Win2K SP4 with terminal services enabled (although i
don't think this is relevant). I'm having problems with Excel crashing
with no error (it just "disappears") when invoking the close method of
an ADO connection object in a VB6-compiled COM object.

I've tested this further by using a very simple VBA macro to create a
connection object and a recordset object, select some data using the
recordset then close the recordset and the connection. About 3 seconds
after the close method has executed the EXCEL.EXE process dies, no
error. I've tried the same in Word and the same happens.

I'm using the MSDASQL.1 provider if this makes any difference, with the
SCO SQL Retriever ODBC driver, but the same code runs fine on a local
machine with the same driver, so it seems that the problem is specific
to this environment. Has anyone come across this before? I suspect
that refreshing MDAC would be the next way forward, but any other
thoughts would be very much appreciated.

TIA

Simon