mdb connected to mssql - I get the write conflict alert box

[Jesper F]

I have a regular mdb-file with linked tables to a MSSQL 2005.
I've created a couple of forms with the linked tables as sources.
A lot of the time I get an error saying "Write conflict - this record has
been changed by another user .... "
and I can choose between "drop changes" and "copy to clipboard".
I'm the only one using the db. I can use SQL to update tables just fine.
Why can't I create regular forms using the linked tables and how can I
correct it?
Thanks

Jesper

 

[Jesper F]

I have a regular mdb-file with linked tables to a MSSQL 2005.

I've created a couple of forms with the linked tables as sources.
A lot of the time I get an error saying "Write conflict - this record has
been changed by another user .... "
and I can choose between "drop changes" and "copy to clipboard".
I'm the only one using the db. I can use SQL to update tables just fine.
Why can't I create regular forms using the linked tables and how can I
correct it?

Solved it. It bit fiels in MSSQL don't have a default value of 0 or 1 then
Access tries to insert a null value into the bit field and it fails.