Write conflict

[Guest]

I get the following error message when i do an edit on a database i am working on
Write Conflic
This records has been changed by another user since you started editing it.....
I am the only user on the system as it is still in development mode. I also can access only two of the options for
this
Copy to clipboard or Drop Changes (The save record option is greyed out
I have looked at this web site for answers, but none have solved it or match the problem.
Any ideas?

 

[Allen Browne]

It is very easy to get this conflict, even if you are the only user.

Create a query into your table, and begin to change a field in the first
row. Leave the query open (without saving the change yet), open the table,
and start editing the same row. When you go do save the change, you have a
write conflict.

Essentially, that means that you need to try avoid dirtying a record
unnecessarily (e.g. do not assign a value to a field in the form's Current
or AfterUpdate event), and explicitly save before opening another process
(e.g. if you are going to open another form to give more detail).

Explicitly save before you move record, apply a filter, remove a filter,
change the OrderBy, reassign the RecordSource, close the form, open another
form or report that uses the same data. Additionally be sure to close any
recordset you open in code, and set your objects (Database, Recordset, Form,
TextBox, etc.) to Nothing before existing any procedure.

Downloading the latest service pack for JET 4 will also help. It's in the
service packs section at support.microsoft.com. (You already have this
latest service pack if the file msjet40.dll is version 4.0.8015.0.)

After all that, you can still get write conflicts from having different
forms/recordsets open if they include BLOB fields (memo, hyperlink, OLE
object).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I get the following error message when i do an edit on a database i am working on:
Write Conflict
This records has been changed by another user since you started editing it......
I am the only user on the system as it is still in development mode. I

also can access only two of the options for

 

[Roger Carlson]

If this is a SQL Server database and you have a Bit field in your table,
look at the following MS Knowledgebase article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278696

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I get the following error message when i do an edit on a database i am working on:
Write Conflict
This records has been changed by another user since you started editing it......
I am the only user on the system as it is still in development mode. I

also can access only two of the options for