I checked db owner is dbo, as your suggestion i use accounting..customer_deposit_voucher and give the result as

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'SQLOLEDB.1' reported an...

MDAC Installed is MDAC 2.6,

here i tried again

INSERT INTO OPENDATASOURCE('SQLOLEDB.1','Data Source=MYDns;User ID=MyUID;Password=MYPwd;').accounting.dbo.CUSTOMER_DEPOSIT_VOUCHER

(batch_id,voucher_id)

VALUES

('A'

,'B10000010101'

)

Result :

Server: Msg 7343, Level 16, State 2, Line 1

OLE DB provider 'SQLOLEDB.1' could not INSERT INTO...

Thanks alot all, i forgot to remove uid and pwd, i just paste from error msg. thanks again.

ali