|
If you look at the user 2 joblog you will see a message saying that the record nnnnnn in file xxxxx is in use by number/job/user. If the program that the user 1 is using is strictly an inquiry only and there is not an update to the file in question, then the program needs to be changed to no do a lock on any records they are viewing. Jim Rubino Senior Business Systems Analyst FIKE CORPORATION 704 South 10th Street Blue Springs, Mo. 64015 (816) 229-6216 Ext. 213 -----Original Message----- From: marsha.barton@xxxxxxxxxxxxxxxx [mailto:marsha.barton@xxxxxxxxxxxxxxxx] Sent: Thursday, October 23, 2003 3:22 PM To: midrange-l@xxxxxxxxxxxx Subject: Record Lockup Problem... Problem: Two users at different workstations have the same record open in a database. User 1 is just viewing the record on their screen. User 2 needs to update or change the open record. User 1 has walks away from their desk and left the record open and displayed on their workstation. User 2's workstation "locks up" waiting for User 1 to close the record so it can be updated. User 2 calls the System Administrator to complain about the workstation being "locked up". It would not be feasible for the System Administrator to go around to each workstation in an attempt to find User 1 and close the record. Is there a way to show the System Administrator the user IDs, workstations, or device names in the situation described above? Marsha Barton / Computer System Tech Brevard County Public Safety / Criminal Justice Services 1040 S. Florida Ave. Rockledge, FL 32955 (321) 633-2006 Ext. 52330 marsha.barton@xxxxxxxxxxxxxxxx _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
