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

Multiple users changing the same record

Two questions:

1) I have a scheduling application (Access 2002) that allows multiple
staff members to edit notes on their meetings and appointments from
their offices. A receptionist views a limited dataset of all of their
appointments and changes the status of an appointment to "Show" as
clients come in the door. She keeps a form open all day that lists that
day's appointments for all staff in chronological order.

Once in a while, while a staff person is editing a record of an
appointment, the receptionist changes the appointment status (using a
button on the form, which runs some code to modify the field). When the
staff person tries to save their notes, Access warns them that someone
else has changed the record. Most of the time, they click the wrong
button and lose their notes...

Is there a way to prevent the receptionist from changing the
appointment record if it is currently being edited by one of the staff?

in Advanced options:
"Default record locking" is 'no locks'
"Open database using record level locking" is checked

2) When I run the built in Access spell checker on a form it runs
through to the next record in the dataset for the form. Is there a way
to keep the spell checker from jumping to the next record?

Thanks in advance!
Jim

Nov 13 '05 #1
4 2267
On 13 Feb 2005 14:55:30 -0800, "Jim M" <ma*****@rci.rutgers.edu>
wrote:

Q1: I would run an update query upon the receptionist's button click,
and then refresh the form to view changes. This update query is very
unlikely to cause a collision, but if it does, good error handling can
go to sleep for a few hundred milliseconds and try again.
That calendar form should probably auto-refresh every few minutes
anyway, to show any changes made by others.

Q2: set the Form's Cycle property to "Current Record"

-Tom.

Two questions:

1) I have a scheduling application (Access 2002) that allows multiple
staff members to edit notes on their meetings and appointments from
their offices. A receptionist views a limited dataset of all of their
appointments and changes the status of an appointment to "Show" as
clients come in the door. She keeps a form open all day that lists that
day's appointments for all staff in chronological order.

Once in a while, while a staff person is editing a record of an
appointment, the receptionist changes the appointment status (using a
button on the form, which runs some code to modify the field). When the
staff person tries to save their notes, Access warns them that someone
else has changed the record. Most of the time, they click the wrong
button and lose their notes...

Is there a way to prevent the receptionist from changing the
appointment record if it is currently being edited by one of the staff?

in Advanced options:
"Default record locking" is 'no locks'
"Open database using record level locking" is checked

2) When I run the built in Access spell checker on a form it runs
through to the next record in the dataset for the form. Is there a way
to keep the spell checker from jumping to the next record?

Thanks in advance!
Jim


Nov 13 '05 #2
Thank you for your help. The query is a good idea. As you suggest, I do
use an autorefresh on the timer evey minute or so. I just use
"me.requery". Would I be better off with "me.refresh". I'm not sure I
fully understand the difference.

It would be easy to use an update query. I use that in other places and
have good results with it. One question related to that: The staff
person may have the record open for quite a long time (editing a note).
If the receptionist tries to run the query then, what will happen?
(Generally speaking the receptionist should change the record before
the staff even opens it, but once in a while...)

Jim

Nov 13 '05 #3
Thanks! I'll check that out.
jim

Nov 13 '05 #4
On 13 Feb 2005 17:45:01 -0800, "Jim M" <ma*****@rci.rutgers.edu>
wrote:

Read up optimistic locking. The record is only locked for the brief
moment when the changes are committed (NOT for as long as the pencil
is showing).

-Tom.

Thank you for your help. The query is a good idea. As you suggest, I do
use an autorefresh on the timer evey minute or so. I just use
"me.requery". Would I be better off with "me.refresh". I'm not sure I
fully understand the difference.

It would be easy to use an update query. I use that in other places and
have good results with it. One question related to that: The staff
person may have the record open for quite a long time (editing a note).
If the receptionist tries to run the query then, what will happen?
(Generally speaking the receptionist should change the record before
the staff even opens it, but once in a while...)

Jim


Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: bdj | last post by:
Hello! Can anyone tell me where to read more about best practices about this: Should I put data in a seperate scheme for tables, packages in anoter schema and create a lot of users that have...
6
by: Gerry Abbott | last post by:
Hi all, Have written some code to limit the concurrent users of a database. Use the Autoexec macro to open a form. When the form opens it increments a value in a table. When the form closes...
4
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a form with multiple pages on it. There is one text field on the third page of the form that I need the user to complete before leaving the form or moving...
1
by: intl04 | last post by:
Are there any problems with multiple user access to the same Access database on a shared network drive? I have 'shared' chosen for 'default open mode'. As for the record locking properties, I...
19
by: davidgordon | last post by:
Hi, I need some pointers/help on how to do the following if it possible: In my access db, I have the following: Tables: Products, Sub-Assembly, Product-Pack Table, Products
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
18
by: Gleep | last post by:
I've searched google intensely on this topic and it seems noone really knows how to approch this. The goal I don't want clients to give out their usernames and passwords to friends, since the site...
1
by: Matt Adamson | last post by:
Guys, We have an issue where we need to control access to specific web pages e.g. if one user is editing a purchase requisition another user shouldn't be able to perform any actions on it. I...
7
by: Birky | last post by:
All, I have scrubbed the archives to see if someone else has requested this type of help but I have not been able to find anything that fits this scenario. I have a form (which is working...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.