473,289 Members | 1,842 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,289 software developers and data experts.

VB6/MS Access point of sale application problem "could not update; currently locked"

Hello, Everyone...

My name is Chris Wogksch. I have a point of sale application developed in VB6 using MS Access 2003 as the database. I've been running versions of this app for over eight years, using vb5/Access 97 and later vb6/Access 2000 and 2003, without issue.

Recently, I've started selling my latest version to liquor stores in my local area. The typical installation setup is a peer-to-peer network with three workstations; a back-office workstation/server (where the database and application software resides), and two front-end register workstations. All workstations pull the software and the data from the same folder on the server.

My problem is as follows... The application works great 99% of the time. However, at peak load they often get the following error message when completing a sale... Run time error -2147467259(80004005) Could not update; currently locked. This kicks them out of the application but they can normally get right back in and then continue, and it doesn't happen again. In severe cases, they have to reboot the workstation before they continue.

One customer runs fine Monday through Thursday and again on Saturday, but experiences the above problem on Friday nights shortly before closing, when they are at their busiest.

The application updates the database by performing an open/update. I've read that I should probably change all updated to a sql execute (insert into or update), but to do so now would be time and cost prohibitive.

If anyone has any suggestions as to why this may be happening and any ideas how I can get around it, I'd greatly appreciate it.

Thank you.
Oct 17 '06 #1
2 4694
PEB
1,418 Expert 1GB
Hi,

Instaed your users working simoultaneously in 1 database it's preferable to have a temporary mdb in each machine where your users save the information... You can gat the consequtive numbers from the centralized database using some kid of sequence but the other things - on local machine and then transfered to the main database - when your users finish their work day and the hard hours?

Best regards
Oct 21 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
I imagine the database is set to shared with edited record locking. Therefore at peak time with multiple users more than one user is writing to a record at the same time. Access won't allow this.

Check the code behind the complete a sale command. You might find that creating a recordset and updating or adding to it rather than inserting or updating data directly to a table will resolve this issue.
Oct 23 '06 #3

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

Similar topics

14
by: Brian Maupin | last post by:
I have a refreshing webcam shot on my site and I was wondering if there was a way I could display how many people are currently viewing it? Thanks in advance.
1
by: Andrew Donnelly | last post by:
I am trying to update a memo field in a table from a form that I have created. The form is unbound, and once the user makes their changes, they have to click the continue button. Once the button...
4
by: Mike S | last post by:
I'm hoping someone can explain the following. I have installed Visual Studio 2003. Setup several web application projects, compliled and ran them with no problem. All of this was accomplished...
3
by: Rod | last post by:
I am getting a strange error when I attempt to run my new ASP.NET application through an ISA server. If I go to the ISA server machine and open up IIS and perform a Browse on the virtual directory...
0
by: hamstak | last post by:
While attempting to perform a build on an .aspx page from within VS 2005 I receive the "Could not load type" error pertaining to the class representing the page. The class is derived from a custom...
1
by: amindi | last post by:
Hi, I wrote a VB6 program to read some data records from a Ms Access database and to write them into a SQL server database.(I use Ms Access 2000 and SQL server 2000).After reading each record in...
0
by: CWogksch | last post by:
Hello, Everyone... My name is Chris Wogksch. I have a point of sale application developed in VB6 using MS Access 2003 as the database. I've been running versions of this app for over eight...
3
by: mistersulu | last post by:
Hi all: I'm using a wx.ListView object with a multi-threaded wxPython app. The list is dynamically generated and accessed across two or more threads. In spite of the fact that I have checks to...
6
by: prknsutton | last post by:
I have a continuous bound form on a FE stored on desktop of each user PC. The BE sits on a local network drive. I have the default record locking to "No Locks" and Open Database Using Record Level...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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: 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...
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)...

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.