SQL Linked tables in access, cant edit newly added rows....why??

[Greg Deputy]

I have some strange behaivor in Access I cant figure out, I'm hoping someone
has seen this before.

I have an Access front end working with linked tables in a SQL 2000
database. The data was recently imported from an access database into SQL.
In some tables something strange is happening. I can edit existing rows,
and add new rows, but when I try to change data in a row that I've added, I
get an error about the data being edited by someone else and i can choose to
drop changes or copy them to clipboard. I'm the only person on the
database.

The table in question has an integer primary key field which is an identity
column.

Any help or insight would be greatly appreciated.

 

[Greg Deputy]

Figured it out on my own...found a KB article that describes the issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;278696&Product=acc

 

[Joe Fallon]

Probably the Bit fields use 3 state logic (True, False, Null).
You should edit the table definitions and not allow Nulls and set the
default to False.