So, Access is linked to an SQL Express Database. I have an update issue.
Currently, the problem is not related to forms/queries/vba.
I can change data in one table using SSMS, but when I try to change the data in Access, opening the table directly, I cannot change anything, except for the first three records - that worked, but now I cannot.
I did have a default constraint for a time stamp field, but I removed the constraint, no change. So, I deleted the field, no change.
I've been down a road like this before, but I think the way I fixed it was to delete the table and rebuild it, but I have a lot of data here that I don't want to have to rebuild...unless that's the only option.
Forgot to add that the error message is: Write Conflict. This record has been changed by another user since you started editing it....
thanks.
Currently, the problem is not related to forms/queries/vba.
I can change data in one table using SSMS, but when I try to change the data in Access, opening the table directly, I cannot change anything, except for the first three records - that worked, but now I cannot.
I did have a default constraint for a time stamp field, but I removed the constraint, no change. So, I deleted the field, no change.
I've been down a road like this before, but I think the way I fixed it was to delete the table and rebuild it, but I have a lot of data here that I don't want to have to rebuild...unless that's the only option.
Forgot to add that the error message is: Write Conflict. This record has been changed by another user since you started editing it....
thanks.
Last edited: