adding a record to a sql table through access

[tziviak2]

I have a backend Table in sql-and I use access as the frontend. when I'm trying to add a record using the .addrecord and .update I get an error of
"run time error 3146"
odbc-call failed

any ideas?

I opened up the recordset with Select * FROM tbl where ...., dbOpenDynaset, dbInconsistent)
thank you

 

[Kleinen]

Since the table is a linked access table to an SQL database, the recordset that you have created by using select is a read only recordset.

You better insert a new record by using
Insert into tbl (col1, col2, col3) values ("a", "b", "c")