Results 1 to 3 of 3
  1. #1
    Cavman is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2012

    Handling multiple user access causing write conflicts?

    Hi, I'm working on a meeting room booking tool that enables up to 100 people to log in and book meeting rooms into a calendar. The front end is installed onto each of the PC's and these access the back end on the server. It works almost perfectly, but the only issue I have is if 2 people try to book a slot at the same time. It produces a Write Conflict error and gives the option to Drop Changes, Save Changes or Copy to Clipboard. Ideally I'd like to trap this error and display a message alerting the user that someone else is possibly booking the same slot and to try again in a moment (then refresh the display to show any changes made by another user). If someone else has already booked a slot, I don't want the second user to have the option of overiding that booking! I want to stop the error displaying and default it to always drop changes.

    Does anyone know a way of doing this? I don't seem to be able to trap the error no matter what I do!
    I thought another option may be to somehow lock the recordset, but only lock the records they're editing (which would be limited to the slots on a single day and for a specific meeting room). Obviously I would want to avoid locking the entire table up! Can anyone suggest a solution for dealing with this? I'm nearing my deadline and have run out of ideas!

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Essex UK
    Have you tried searhing the Access help files for "Record-level locking"
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Cavman is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Oct 2012
    I've reading lots, but not really got my head around it yet!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Handling Multiple Selections in a List Box
    By Zetony in forum Access
    Replies: 2
    Last Post: 11-02-2011, 02:21 PM
  2. Access 2010 / Windows 7 conflicts?
    By SteveF in forum Access
    Replies: 2
    Last Post: 07-22-2011, 03:37 PM
  3. Handling multiple inputs on form fields
    By wake74 in forum Access
    Replies: 1
    Last Post: 09-14-2010, 11:06 AM
  4. Using variables to trap write conflicts
    By ajetrumpet in forum Programming
    Replies: 2
    Last Post: 09-07-2010, 12:54 AM
  5. Replies: 1
    Last Post: 06-02-2010, 10:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums