| re: Preventing users from Switching Forms AccXP
On Mon, 3 Nov 2003 16:11:19 +0000 (UTC), "Baz'noid"
<barry@rtd.uk..com> wrote:
[color=blue]
>Hi all,
>
>As the size of my database and the number of users grows, i've found a
>horrible bug in the system with a very simple solution (but i don't know how
>to implement it)...
>
>If two people are accessing the database simultaneously (literally at the
>same time), things slow down a little. No problem. The problem becomes if
>one user switches from one form to another from a customer's record (in this
>case, having the details open as the main form, and payments form, order
>detail form) and edits it. If someone else is editing a record at the same
>time, access instantly confuses itself and corrupts the data in the field
>trying to be edited.
>
>This has caused unbelievable problems, especially since we lost over 200
>customer records as a result at one point!!! I have figured out the
>solution is to ensure each user can only have two forms open at a time, and
>being forced to close the form they are leaving when going to another one,
>thus ensuring the data is saved correctly.
>
>For example:
>
>Orders by Customer form open (always is)
>Order Details form open
>
>User finishes entering data on the order details form, and wants to open the
>Payments form. I want to force the user to close the order details form
>before allowing the payments form to open.
>
>Any suggestions on the coding to do this?
>[/color]
Ooh, you need to split this into frontend and backend - the frontend
for the code and the backend for the data. There is even a wizard for
this if you need.
That should deal with all of the issues you mention.
- Jim
| 
