473,320 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Write Conflict Error Editing Memo Field

I’m experiencing the following Write Conflict Error when editing a “Memo” field on an MS Access subform:

“This record has been changed by another user since you started editing it. If you save the record you will overwrite the changes the other user has made. … “
Options: Copy to Clipboard or Drop Changes

Environment: Access 2003, SQL Server 2005, Windows 7 Pro

I have a main form with one subform.

The main form is not bound to any table or query. All of its controls are populated by its On Open Event handler. One of these controls (a textbox) contains the subform’s Linked Master Field.

The subform is bound to an SQL Select statement whose underlying table is an SQL Server table linked via ODBC. The table contains some fields with a character datatype.that exceeds 255 characters (e.g., ntext, nvarchar(256), etc). When the table design is viewed in Access these fields appear as Memo fields.

Whenever I edit any one of these fields on the subform, and then move to a different record, I get the Write Conflict error; and there are no other users.

Changing the datatype to nvarchar(255) solves the problem, but that is too limiting for my client.

Is there a solution to this problem?
Jan 5 '13 #1

✓ answered by normturgeon

I followed other threads and found a solution offered by Danny J. Lesandrini in November 2005, viz:

“Add a timestamp field to the table in SQL Server, and everything will be fine. The problem is that, because of the memo field, the client can't determine with certainty that the record hasn't been changed by someone else. Just add the timestamp and see what happens.”

That worked for me.

Thanks Danny

2 2415
I followed other threads and found a solution offered by Danny J. Lesandrini in November 2005, viz:

“Add a timestamp field to the table in SQL Server, and everything will be fine. The problem is that, because of the memo field, the client can't determine with certainty that the record hasn't been changed by someone else. Just add the timestamp and see what happens.”

That worked for me.

Thanks Danny
Jan 5 '13 #2
NeoPa
32,556 Expert Mod 16PB
Good for you Danny. Thanks for posting. I'll take the unusual step of flagging your response as Best Answer, as it does provide a good solution to the problem and it's expressed clearly :-)
Jan 6 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Fardude | last post by:
I have a few tables in SQL Server 2000 and a small Access 97 that has linked tables used to insert/update/delete into SQL Server 2k tables. Everything works fine except Updating one of these...
0
by: Smriti Dev | last post by:
Hi, I have a ms access table table which is linked to a mysql database table. I have used a ms access form to edit records. However, when I attempt to edit a record I get a write conflict error...
0
by: manning_news | last post by:
Using A2K. I've got a form for clients that has a subform that is a cartesian product between client ID and a lookup table for types of income. So each client has the exact same number of income...
3
by: rivka.howley | last post by:
I recently added some code to the BeforeUpdate event of a text box on a form. The code uses the new value in the text box to recalculate some values in another table, which is shown in a subform on...
1
by: S.Dickson | last post by:
I have a database with access as front end and Mysql as back end. I am gettting the following 'Write Conflict' Error. when i am on my order form, This form does has a subform where i enter all the...
2
by: mrsgwen90 | last post by:
I am trying to update a record using access as the front end and VB 6.0 as the backend. I am using a SQL statement to accomplish this. But I am getting the "Write Conflict Error". I have tried...
3
by: gazsharpe101 | last post by:
Hi everyone, I am doing some work on my company's database. It is a MS Access 2003 front-end with an SQL back-end. Recently, I have asked the database administrator to add some new fields to...
4
by: AccessBeetle | last post by:
I have a simple form based on a table which has several controls and subforms. When I open the form and try to edit things it gives me this trritating error saying "Write Conflict". It has three...
4
by: Rolrox | last post by:
I've discovered that in Sybase, I had a field/column whose datatype was defined as "bit" which also permitted NULL values. When I changed this to smallint, the write conflict went away.
1
by: Ryan Swaby | last post by:
I have an access form that is bound to an ado recordset using the following code in the form open event. Dim cn As ADODB.Connection Dim rs As ADODB.Recordset 'Use the ADO...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.