Access front end can't edit SQL 2005 data after adding "Bit" field

[gfocaraccio]

Hi,

I've been using Access 2003 front end for basic data manipulation on a SQL 2000 database. I recently restored the database to a 64 bit SQL 2005 server. All access queries and forms worked perfectly even after modifying fields, setting constraints and adding fields to the database using the SQL2005 management studio. However as soon as I add a "Bit" field to a table, I can only view and not updated data via Access. I get a message when trying to update the record that another user has modified the record since I started editing the record. What's weird is that the table has other "Bit" fields (that were there before migrating to SQL 2005) in it which work fine.

Anyone, any ideas?

 

[Meltdown]

Open the table in design view in the Management studio, click your bit field, in the column properties, set the Allow Nulls property to NO, set Default Value or Binding property to 0 , save your table and everything should be OK

 

[gfocaraccio]

Thanks Meltdown, this worked! Just had to set binding to "(0)" in SQL 2005. Thanks again.

 

[lala]

Open the table in design view in the Management studio, click your bit field, in the column properties, set the Allow Nulls property to NO, set Default Value or Binding property to 0 , save your table and everything should be OK

thank you!!!
2 days of trying to figure it out and then i saw your post