Run Time error 3146 - ODBC Call Failed

G

Guest

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
Runtime Error: 3146 4
ODBC call failed : Error # 3146 6
3146 Error, and Invalid Argument Value error 2
Run-time error 3146 ODBC--call failed 4
What went wrong - Please advise! 2
Please help with ADO Code 1
ODBC Call Failed 2

Top