Access frontend can't update 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?

 

[PHV]

Either don't allow the Bit field to be Null or add a TimeStamp field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gfocaraccio]

Thanks a lot. I modified it to not allow nulls and set the default binding to "(0)".
Thanks again.