Using A2003. I've got an FE with a main form with a subform. The
subform is a mixture of bound and unbound fields. The main form is
unbound and all it has on it is a combobox to choose a patient's
name. Once the patient is chosen, the subform refreshes to show that
patient's data. The problem I'm having is that 2 or more users could
select the same patient and attempt to update the subform. If user #2
tries to update a bound field (haven't tried unbound yet) on the
subform, they get a "beep" and the "no edit" icon appears in the
record selector on the left-side. I'm trying to trap that to display
a message to them that the patient is being edited by someone else.
But I cannot seem to figure out where the error is occurring. I've
set breakpoints in the Form_Error event, but it won't trap the error.
I've set breakpoints in events for various bound fields on the subform
but I still cannot trap the error. I would like for other users to be
able to view the patient's data while another user is editing, just
not be able to edit it.
The BE mdb is set to Shared, and "Edited Record".
Thanks for any help or advice. 4 1313
Greetings,
In a multiuser scenario as you describe, the solution you could try is
to have the users perform the edits locally and then submit the edits to
the back end db. Make sure you have referential integrity set (Primary
keys, foreign keys, relationships between the tables). This is how you
control duplicate data entry and invalid updates/deletes. As for
performing the edits locally and then submitting the edits to the
backend - this will reduce record locking - write conflicts (dead
locking on a server db).
Rich
*** Sent via Developersdex http://www.developersdex.com ***
On May 5, 10:44*am, Rich P <rpng...@aol.co mwrote:
Greetings,
In a multiuser scenario as you describe, the solution you could try is
to have the users perform the edits locally and then submit the edits to
the back end db. *Make sure you have referential integrity set (Primary
keys, foreign keys, relationships between the tables). *This is how you
control duplicate data entry and invalid updates/deletes. *As for
performing the edits locally and then submitting the edits to the
backend - this will reduce record locking - write conflicts (dead
locking on a server db).
Rich
*** Sent via Developersdexht tp://www.developersd ex.com***
*_alt.0
20KDownload
Will try. Thanks for the advice.
"EManning" <ma**********@h otmail.comwrote
Using A2003. I've got an FE with a main form with a subform. The
subform is a mixture of bound and unbound fields. The main form is
unbound and all it has on it is a combobox to choose a patient's
name. Once the patient is chosen, the subform refreshes to show that
patient's data. The problem I'm having is that 2 or more users could
select the same patient and attempt to update the subform.
In multiuser environments, each user should have his/her own copy of the
Front End, linked to shared tables with data, in the Back End. That will
alleviate your problem... provided you use proper locking, which is
certainly possible...
Larry Linson
Microsoft Office Access
If user #2
tries to update a bound field (haven't tried unbound yet) on the
subform, they get a "beep" and the "no edit" icon appears in the
record selector on the left-side. I'm trying to trap that to display
a message to them that the patient is being edited by someone else.
But I cannot seem to figure out where the error is occurring. I've
set breakpoints in the Form_Error event, but it won't trap the error.
I've set breakpoints in events for various bound fields on the subform
but I still cannot trap the error. I would like for other users to be
able to view the patient's data while another user is editing, just
not be able to edit it.
The BE mdb is set to Shared, and "Edited Record".
Thanks for any help or advice.
On May 6, 1:47*am, "Larry Linson" <boun...@localh ost.notwrote:
"EManning" <manning_n...@h otmail.comwrote
Using A2003. *I've got an FE with a main form with a subform. *The
subform is a mixture of bound and unbound fields. *The main form is
unbound and all it has on it is a combobox to choose a patient's
name. *Once the patient is chosen, the subform refreshes to show that
patient's data. *The problem I'm having is that 2 or more users could
select the same patient and attempt to update the subform.
In multiuser environments, each user should have his/her own copy of the
Front End, linked to shared tables with data, in the Back End. *That will
alleviate your problem... provided you use proper locking, which is
certainly possible...
*Larry Linson
*Microsoft Office Access
If user #2
tries to update a bound field (haven't tried unbound yet) on the
subform, they get a "beep" and the "no edit" icon appears in the
record selector on the left-side. *I'm trying to trap that to display
a message to them that the patient is being edited by someone else.
But I cannot seem to figure out where the error is occurring. *I've
set breakpoints in the Form_Error event, but it won't trap the error.
I've set breakpoints in events for various bound fields on the subform
but I still cannot trap the error. *I would like for other users to be
able to view the patient's data while another user is editing, just
not be able to edit it.
The BE mdb is set to Shared, and "Edited Record".
Thanks for any help or advice.- Hide quoted text -
- Show quoted text -
Each user does have their own FE. The BE is set to Shared and "Edited
Record". Should it be set to something else? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: aka |
last post by:
Hi
I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to
OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect
instance as tcpip node and then the Host DB cataloged on that node...this
works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get
SQL1334N.
Does anyone has an idea?
Thanks
|
by: aj |
last post by:
DB2 WSE LUW 8.1 Fixpak 5
Red Hat AS 2.1
Has anyone ever seen a db2diag.log indicate that a trap file
was written, but it is *not* written?
For the 3rd time in 18 months, I had a production server abend
and shut itself down w/ a signal 11 ala:
2005-10-30-02.05.02.430065 Instance:md Node:000
|
by: Carson |
last post by:
Hi,
I am now writing a c-code, which is extremely computational extensive.
My computer is 2.8GHz Pentium (supports hyperthreading), using cygwin cc
(latest version) to compile with the followings:
cc -c -O3 -mcpu=i686 $(FLIST)
when i run my program, (a.out), it takes a quite a bit of time to finish,
|
by: Sreedharan |
last post by:
Hello everyone,
I am a VC++ programmer.
When i develop a multi-threaded application in C++, I prefer to use
worker thread, so that the main thread and worker thread can
communicate using messages.(i will prefer to use PostMessage than
SendMessage API in order to avoid any dead locks )
I prefer to post messages to a thread , instead using call back
functions(passing pointer to another thread's function.)
|
by: David Stephen |
last post by:
Has anyone got some generic code that identifies when a session has timed out in ASP.NE
If I add a session variable in Session_Start then when the session times out it readds the variable in Session_Start so I can not check this variable
I do not know if I will have a login type page where I can set the variable so the application may come in on several pages
The only way is to check each session variable on each page
It has been...
| |
by: pemo |
last post by:
Ambiguous?
I have a student who's asked me to explain the following std text (esp. the
footnote).
6.2.6.1.5
Certain object representations need not represent a value of the object
type. If the stored
value of an object has such a representation and is read by an lvalue
|
by: Eddie |
last post by:
In Microsoft Access form, combo box can be binded to the table or query and
can be shown as multi column, getting a actual binded column and showing
columns.
I'm struggling to make a multi-column combo box now but in vain.
The combo box in VC.NET seems not having multi-colmn property. Is it true?
If I can't use combo box as a multi column container, how can I show the
information like
Select your name :
|
by: pemo |
last post by:
As far as I understand it, a trap representation means something like -
an uninitialised automatic variable might /implicitly/ hold a bit-pattern
that, if read, *might* cause a 'trap' (I'm not sure what 'a trap' means
here - anyone?).
I also read into this that, an *initialised* automatic variable, may never
hold a bit pattern that might, when read, cause a 'trap'. I.e., if an auto
is explicitly initialised, it may *never* hold a...
|
by: temper3243 |
last post by:
Hi
Can someone explain me what is happening below ? Why is it printing
401380
$ cat scanf.c
#include<stdio.h>
int main()
{
int i;
scanf(" %d",&i);
|
by: Yevgen Muntyan |
last post by:
Hey,
Is it correct that number of value bits in int and unsigned
int representation may be the same? If it is so, then INT_MIN
may be -(INT_MAX+1) (in mathematical sense), i.e. abs(INT_MIN)
is not representable in int or unsigned int. Or is it guaranteed
that magnitude of any int value fits in unsigned int?
Yevgen
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |