473,320 Members | 1,799 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 Only on Server

110 100+
I have 2 odd issues occurring on a server.

First - I'm getting a query write conflict error (image attached). This error is not occurring on any other computer but when I test on the deployment server I get the error. I've tried to replace the front end and the back end with new versions of the software (versions that are working fine when deployed on another computer).



The server has Access 2010 installed. (MS Server 2008r2)

I've tested this problem on computers running 2010 and 2007 (both with Windows 7) - the problems do not occur on these computers. It seems to be a problem with this installation.

As always, any assistance is appreciated.

Gunner
Attached Images
File Type: png Write Conflict.png (17.8 KB, 610 views)
Jan 7 '14 #1
10 1565
NeoPa
32,556 Expert Mod 16PB
This error generally indicates that two separate users (or, more technically, processes) have flagged that same part of the database for update work.

Your configuration settings control how the process should handle conflicts, as well as how much of the database is considered to be the relevant part.

I suspect the difference is probably more with how Access has been configured (Options etc) than which OS it's running on. Including the OS is definitely the right way to ask the question, of course. I just don't think it'll turn out to be the issue on this one. I'd compare all your different options between the machines that work and those that don't and see what's different.
Jan 7 '14 #2
dgunner71
110 100+
Thanks for your reply, NeoPa.

I have some more information that may shed some light on this issue.

The problem began on my latest update which incorporated a new field from a separate table. I currently have my form's record source bound to an SQL statement (entered directly into the record source - that is to say, not a query).

Prior to the update, the record source SQL was just a single table. After my most recent update, I needed to bring a new field in from another table for the filter. When I bring this second field in, I am getting the Write Conflict (still just on the server - all other computers work fine). I would like to correct this issue to work on the server if possible. I've included the before and after SQL statements below; not sure if this will help at all.

Original SQL Record Source statement - work fine:
Expand|Select|Wrap|Line Numbers
  1. SELECT tblInventoryTransactions.*
  2. FROM tblInventoryTransactions; 
New SQL Record Source statement - raises write conflict:
Expand|Select|Wrap|Line Numbers
  1. SELECT tblInventoryTransactions.*
  2.    , tblInventory.txtItemType
  3. FROM tblInventoryTransactions 
  4.    INNER JOIN tblInventory 
  5.       ON tblInventoryTransactions.numTransactionItemID 
  6.          = tblInventory.AID;
As you can see the new statement is not overly complex - it only adds [txtItemType].

As always, your help is greatly appreciated.

Kind regards.

Gunner
Jan 7 '14 #3
Seth Schrock
2,965 Expert 2GB
Is there a field in any of the involved tables that has a bit type? If so, you must have it set to not allow null values. If you do, it will let you enter the record the first time fine, but then it won't ever let you edit that record if you left that field null. What I do is to set my checkboxes to have a default value of False so that all new records pass a false value (unless I change it to True) and then my issue goes away.
Jan 7 '14 #4
zmbd
5,501 Expert Mod 4TB
This is valid for SQL-Server/MySQL.
This does not hold true if the backend is an Access file.

I'm haveing issues trying to understand why you are using a server as as workstation, that is NOT what it is designed for... I suspect that the server is creating a multiple instance of the files when you attempt to run Access from the zero-hundred terminal on the datafile.
Jan 7 '14 #5
dgunner71
110 100+
zmbd -

I have both the back end and the front end on the server. Users log in via remote desktop (scattered across 3 countries).

Gunner
Jan 7 '14 #6
dgunner71
110 100+
Seth -

I'm sure I do have Yes/No fields in my tables - I'll ensure that I have a default value set for all these and I'll let you know if this changes anything.

For the time being, I've created a work around that may actually work out better. In any event, I would like to understand why this is happening.

Thanks.

Gunner
Jan 7 '14 #7
Rabbit
12,516 Expert Mod 8TB
Undo your change and see if that really is the cause.
Jan 7 '14 #8
Seth Schrock
2,965 Expert 2GB
If the bit fields are the problem, all you have to do is make sure that you have passes either a true or a false value to it. From what I have read, it is a good practice to make it so that the field cannot be null, as it forces you to pass it a value and then you never forget to do so.

I do know that that is the error message that you receive when this is the problem. However, I'm sure that this isn't the only issue that would cause the message.
Jan 8 '14 #9
NeoPa
32,556 Expert Mod 16PB
Have you looked at the options for Access and the VBAIDE (Code Window)? This is where I still expect you to find answers.
Jan 8 '14 #10
dgunner71
110 100+
All -

I found the problem - there was a piece of code that was attempting to update the tblInventory table (the same table that I added to the SQL statement / Record Source). I'm not sure why my other laptops let this query run without the write conflict, but this was indeed the problem.

I over looked the DoCmd.RunSQL statement and the fact that I was only having the problem on the server (which historically has presented some odd issues) I just wasn't looking in this area.

Thanks to everyone for your help - this site is the best site on the internet by and by!

Gunner
Jan 8 '14 #11

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

Similar topics

48
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
7
by: David Laub | last post by:
I have stumbled across various Netscape issues, none of which appear to be solvable by tweaking the clientTarget or targetSchema properties. At this point, I'm not even interested in "solving"...
10
by: Mark | last post by:
Are there any known issues with developing ASP.NET web applications directly on Windows 2003 Server running VS.NET 2003 Pro, SQL Server client tools, and using VSS for source control? Essentially...
3
by: Adrian Parker | last post by:
Anyone come across anything like this before.. If I do a server transfer to a new page, at the top of the page, the contents of the <TITLE> in the <HEAD> section is displayed above the contents...
10
by: Robert | last post by:
I have an app that was originally 1.1, now migrated to 2.0 and have run into some sporadic viewstate errors...usually saying the viewstate is invalid, eventvalidation failed or mac error. My web...
3
by: KWilliams | last post by:
I'd like to get some good advice about our old ASP site. You can see our home page at: http://www.douglas-county.com/ ....and an example application page at:...
6
by: Marc Castrechini | last post by:
This is a classic double hop delegation issue, however its the first time we are setting this up so we are doing something incorrectly. If we run through the IDE or using a localhost path on the...
1
by: GaryDean | last post by:
We have been developing all of our .net applications on 32 bit windows using 32 bit SQL Server. We are being asked to now deploy to servers running 64bit windows and 64bit SQL Server. Are there...
0
by: 83rish | last post by:
we recentely tried migrating our databases from 2000 to sql server 2005.The migrated databases had some issues like collation issues,so we created the scripts for each databases and then updated...
3
by: eschneider | last post by:
Just some common issues with WS: Using custom objects: When objects change, seems you are always fixing some issue. Update references, which sometimes does not work. Deployment: Weird errors...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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.