write conflict

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have an application which use MS SQL Server 2000 as backend.
I just created a table and try to enter some data, but I got write
confict message like following:

"The record has been changed by another user since you started edting
it, if you save the record you will overwrite the changes other user
made"

I just created the table and I am the only user to use the table. I am
able to enter the data from Enterprise Manager to enter.

I just wonder where the message come from and any work around for
this?

Your help is greate appreciated,

iccsi
 
You will get this message if you have any code which sets or edits a value,
and you also change it manually in a form.

HTH,

Rob
 
You will get this message if you have any code which sets or edits a value,
and you also change it manually in a form.

HTH,

Rob











- Show quoted text -

It is a brand new table, there is no code to edit the table. I edit
the table using the table from MS Access, but not form form.

Thanks again,


iccsi
 
If you are the only user, try ignoring the error message, and just say OK..
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://access.mvps.org
Co-author: "Access Solutions", published by Wiley





It is a brand new table, there is no code to edit the table. I edit
the table using the table from MS Access, but not form form.

Thanks again,

iccsi- Hide quoted text -

- Show quoted text -

There is no ok button, only drop update or copy to clipboard.

thanks again,


iccsi
 
Back
Top