Run Time error 3146 - ODBC Call Failed

S

stabilo

I have a db with a lnked tbale coming from a SQL Server. The following code
lead to an error on the update line :

[...]
Set db = CurrentDb
Set rstmessage = db.OpenRecordset("mytable", dbOpenDynaset)
rstmessage.AddNew
rstmessage("Filed1")= "value1"
rstmessage("Filed2")= "value2"
rstmessage.Update ' Fails here
[...]

Error is : Run Time error 3146 - ODBC Call Failed.

The above code worked perfectly whne the table was local to the DB. Any idea
?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Call Error 2
Help Error 3146 ODBC call fail 0
ODBC call failed : Error # 3146 3
3146 Error, and Invalid Argument Value error 2
Runtime Error: 3146 4
3146, I know you have talked about before but.... 0
ODBC Call Failed 2
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0

Top