Access Linked Table unable to update or delete existing records in SQL Server Table

This usiually appears when you have a form bound to the data, and you then have some SQL that is updating the data other than through the form interface, and then you try to do just that.

Is usually solved by requerying the form after each VBA data change to commit the record & reload.

No forms. Just a linked table.

Kevin

How are you connecting. Is this a mdb via ODBC or adp?

ODBC. I'm currently thinking it has something to do with a Bit datatype I defined in SQL Server.

Per chance, do you know how to define a boolean in SQL Server that shows up as a True/False value in Access?

Kevin

That solved the problem. I also found some notes on using timestamp - it is a bigint which Access can't handle either. The solution was to use datetime and set the default value to getdate().

Thanks!

Kevin