Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 2nd, 2013, 03:37 AM
Registered User
 
Join Date: Nov 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Locking records problem

Hi all

I would like to find anybody help on the problem of access locking records. I have a backend data and front end application interface with multi-users database built for data entry. If one of the multi-users needs to update a piles of records with same criteria, may be 500 records or more at one time. When the updating not being finished, another users also come in for updating some of the recodes amongst the above piles of records. I want the 2nd/3rd .....users queue up and wait updating finished one by one.

What codes can i assigned in the program?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem "Locking Up" Access 2007 tcarnahan Access VBA 4 June 23rd, 2010 08:27 AM
ADO not locking records twentysixdays Access VBA 2 July 6th, 2009 06:52 AM
Access to SQL Server locking problem echovue Access VBA 2 December 22nd, 2006 08:10 AM
Access 97 Table locking problems timmaher Access VBA 1 November 5th, 2003 11:05 AM
locking of records vincentc Classic ASP Professional 4 August 19th, 2003 04:40 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.