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

Top