Update Problem

[neerajav]

I have an MS access application whic has link tables to a SQL server database.I have added a new column wiht property:Yes/No to this table and I have linked the new table to my Access database.I use this column as a check box in an MS Access Form.WHen I update this checkboz, I get an error:Another user has tried to update ths record.Drop the changes now.Iam ure no one else is using his table to update other than me. I tried to import the whole table to Access insted of linking it and the update works fine.
Another starange this is there is another usre who has this application and he does no have he nex checkbox or the link to the new table with the new column added in it.and for him the update to this table works OK.
pls. let me know f I ahve to set any extra properties while linking th etable? or am I linking it OK to Access?Dont know where my understanding is skewed....
pls. help....

 

[The_Doc_Man]

OK, here is a POSSIBILITY - not a certainty.

Sometimes when you have a form bound to a table/query and you attempt to change a field, if you have event code behind the table that ALSO tries to explicitly make a change other than to the underlying record that drives the table (like maybe running something in SQL within the event), you can get a collision between the update of the event code and the update of the open form.

Not gonna swear that you have this case, but it is something that has happened to me more than once.

As to why you have the checkbox and someone else does not, is there some sort of code in a Form_OnCurrent event that enables or disables some controls? And the conditions to enable/disable don't apply to this other person somehow? Perhaps permissions-related?

 

[neerajav]

Thanks for the Reply...I checked this and there are no events in the Code.If I look into the Link Table and try to update any record directly in MS access, i still get the same error:Another user has changed the record.Copy to the clipboard or drop the changes.But Iam able to insert a new record both thru the form and thru the table directly,and Iam able to update/delete this record that I inserted newly...Is there a lock or something on the table? Can there be a lock for all existing records and the user can enter a new record alone?????
There is an olde version of the same application which does not have my checkbozes and changes.that application works fine though I have added the new columns to the sql table.But in tihs case, it is not linked to the MS access....
Iam confused!