Hello
first of all i'm sorry because this topic was in this forum but the other topic was closed.
I have the same error
quote:
if i put the statement in a trigger the
message MSDTC on server '' (NOTE there is no servername in the quotes) is unavailable.
but my error is when i try to insert into a table from acces
GRAR_Server.Execute "Insert Into OMI01 (DOCUMENTO,FECHA,NUMERO,OBSERVACIONES,REFERENCIA,SUCURSAL,BODEGA,SERIE,STATUS,TIPO_MOV) Select a.DOCUMENTO,a.FECHA,a.NUMERO,a.OBSERVACIONES,a.REFERENCIA,a.SUCURSAL,a.BODEGA,a.SERIE,a.STATUS,a.TIPO_MOV From OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\CONFIGURACION\BDTRANSAC.mdb';'admin';'',womi01) a Where a.NUMERO = '" & CODIGOW & "' OR a.REFERENCIA = '" & CODIGOW & "'"
I hope you can help me
pd: sorry by my English but I'm not American
<center>
</center>
MSDTC on server '' is unavaliable
Posted - 2007-11-27 : 13:47:41
