November 17, 2005 at 2:10 pm
I get the following message when a user attempts to add data to a "Remarks" field (varchar(1000)). "This record has been changed by another use since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes." The "Save Record" option is greyed out. Permissions are read/write for the login; I'm not sure where to go from here. I have even tried connecting to the tables via Access 2003 and the same message appears when trying to modify the "Remarks" field, hence, I don't think that its the application.
Carpe diem!
November 17, 2005 at 4:04 pm
This error can be caused by some of the following:
Do you have a bit field in the table that allows nulls?
Do you have a unique key on the table that Access recognizes?
Michelle
November 29, 2005 at 2:09 pm
Thanks Michelle
There was a bit field that allowed nulls in a table that was giving me the same grief as the originator of the thread.
You solved it.
Hugh
November 29, 2005 at 3:18 pm
Thanks guys!
Carpe diem!
November 29, 2005 at 3:22 pm
Glad my hints helped.
Michelle
Michelle
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply