473,856 Members | 1,710 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access locks and VB/VB.NET

1 New Member
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!
Oct 29 '07 #1
1 3307
3,080 Recognized Expert Specialist
Access hasn't been designed for running on a webserver, so there's some extra risk in using it.
For some background info see:
Access database on the web:
Don't use Access on the web:

For the locking problem I can add that when the Access database is opened by a user (or by code) to change the design, then even when the database has been declared "shared" it will get locked.

Oct 30 '07 #2

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: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
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: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.