Search results

Just saw your message above about edited record locking option, Ken. How do I use that? Is it in the options somewhere, or do I set it in the code? BTW I'm using Access 2010

That sounds logical Ken. How would I save edits? Sorry, I'm still relatively new to Access! Would I need to put some code to save in the on-click event that opens the reservation form?

Just as a bit of background, the main table consists of a record for each room, date, timeslot and booking name. There are also 'lock' and 'select' flags for each record. A user selects the slots they want by clicking on the 'select' flag, and then clicks a confirm button which opens a recordset...

We deliberately set up the situation of 2 users booking at the same time to test the outcome. The error never occurs when a single user is booking, but with 100 people using the database there's a good chance that 2 people will try to book the same room and day at the same time!

When I read up on locking options, I came to the conclusion that recordset locking is set on as standard and that's what actually causes the write conflict error! Does that sound correct?

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...