I have a Access 2002 (saved as 2K format) front end to a SQL Server (2000 I believe) and everything worked fine until I added 30 new fields to the main table. All of these fields are data type Bit and all are initialized to zero. I can add new records without any issues. The problem is that any time I try to update or delete a record I get the dreaded "Write Conflict..." msg in Access. If I use an older version of the system without refreshing the linked tables I have no problems. This behavior is also exhibited if I try to update/delete a record directly in the table so I know it is not something in my forms. Any help would be greatly appreciated.
Ron
The solution was to change the data type on the SQL Server to a 1 byte text field and poputate it programatically rather then having it directly bound to a control such as a checkbox. I never got a good answer as to why this was happening so I had to use the previously described workaround.
No comments:
Post a Comment