write conflict

[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

 

[Rob Parker]

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

 

[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











- 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

 

[Arvin Meyer]

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

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

 

[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