Hi guys,
I've been stuck on this problem for days now at work and its driving me insane. Basically there is a system in place at multiple locations that is an open source project running with ms access. This system holds customer records and order data, and its written in asp.
We have a web service that sits at each of these locations written in vb.net and it is called by our system, on one of our servers. The web service is used online, customers create orders, most of this data gets stored in our sql server database (which omg i wish they would use instead of access... ), and then gets sent over the web service. I open one connection to the database for the duration of the call, which inserts multiple rows into two tables.
At the same time, there is an interface running on the local sites, which refreshes every 10 seconds or so. I'm not entirely sure what happens in this code, because of the poor coding and many include files, but I can gather that it is at least doing a read of the database, and there is possibly and update being made too.
It seems as though if that interface is refreshing at the time of the order being placed with the web service, I will get a database lock error through the web service.
Is it possible in access to specify NOLOCK, or only row locks for updates? I Thought that access allows a number of connections to the database before it starts locking like this. I have that default lock setting in access to be 'no locks', i've, I found online some extra properties to add to the connection string in the web service that allow shared mode and no locking.
In asp with a record set, can i stop a table being locked with select and/or update statements? I feel like i've made a number of changes to all sides of things and nothing helps.
I've also been told they dont ever encounter problems instore, when staff create new orders locally. Multiple members can create orders at the same time too. This makes me feel as though its a problem with the web service, however I never receive the locking issue unless I have that interface running too.
I know its a fairly long post and may not make a whole lot of sense, but if you have any questions/answers for me, ill give you a clearer understanding.
Thanks guys!
1 3299 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Bruno Barberi Gnecco |
last post by:
I'm developing a collaborative application in PHP which accesses
local files and may modify them. How can I synchronize the multiple
accesses? Note that I'm not worried about the algorithmic part of the
problem, or how to avoid conflicts, which I know how to solve; I just
need a few atomic primitive shared among any PHP processes that may be
running. I could even have a separate process serializing all operations
if such a thing is...
|
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB 7.2 environment, the choices
the optimizer makes often seem flaky. But this last example really
floored me. I was hoping someone could explain why I get worse
response time when the optimizer uses two indexes, than when it uses
one. Some context:
|
by: ano1optimist |
last post by:
We've got users sharing a database where the front end apps reside on
the local PC while the backend app is on the network. We have
repeated problems where certain users lock the database causing other
users to get the Run-time error , currently locked
by user 'admin' on machine 'xyz' when trying to log into the database.
The users have a "/runtime" command on the property of their desktop.
Can you clarify how the runtime works? My...
|
by: Noni Ledford |
last post by:
Hi - I have a database on a network, and each user logins using a
shortcut from his PC to the shared database. There is a table created by
a make-table query that locks up whenever more than one user is in the
database. It doesn't matter that the users open completely different
clients, forms, etc, as long as there are more than one user opens the
database this table locks up. And the function that recalculates the
amount doesn't work.
...
|
by: Leinad Kong |
last post by:
I'm using Access 2002, as front-end and back-end as well:
1) I faced database corrupted problems, when more than 1 user edit
concurrently.
I'm using All-records Locking, and open-exclusively as default.
But, still face the same problem: Database corrupted! (But, it allows
to be repaired)
2) I found that the relationship linkage between those related
tables(which corrupted) was disconnected/lost after problem (1)
| |
by: Greg Copeland |
last post by:
I am running python on VxWorks. In the course of operation, a vxworks
tasks writes to a reserved area of memory. I need access to this chunk
of memory from within python. Initially I thought I could simply
access it as a string but a string would reallocate and copy this chunk
of memory; which is not something I can have as it would waste a huge
amount of memory. We're talking about something like 40MB on a device
with limited RAM. I...
|
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button remains desperatly grayed.
It also seems impossible to open the library in another Access instance
|
by: rlwaggs |
last post by:
Is there a problem with linked tables in Access causing share locks in SQL server if my SQL Server account has read only permissions?
The IT group I work with has a negative view of Access. I use Access to query Oracle and SQL Server data sources for most of my ad hoc data needs.
I hear quite often to "be careful" when using Access to read sql server data becasue it can cause share locks in sql server.
My response has always been, then...
|
by: jsacrey |
last post by:
Hello everybody,
I've got a bit of a situation that I could use some guidance with if
possible. I work for an auditing firm where my users audit electronic
shipping data for customers to see if they've been overcharged for
shipments by truck and rail carriers.
99.9% of the time, one of our auditors needs to see all data sent by a
customer in datasheet view so that they can sort records in many
different ways looking for duplication...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |