Jim Dettman
jimdettman at earthlink.net
Fri Aug 20 15:35:07 CDT 2004
John, Reboot required. Jim (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Bartow Sent: Friday, August 20, 2004 2:14 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Clear Locks Via OS (was: A table that can'tbeduplicated) Jim, Stuart, etal: OK, I going to give disabling OPLOCKs a try. One question - is rebooting required after changing this setting? I couldn't find the answer. (Just scheduling issue really - if so I'll have to do it after work hours). Thanks, John B -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman Sent: Thursday, August 19, 2004 6:45 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Clear Locks Via OS (was: A table that can'tbeduplicated) John, Not sure I understand this last bit: <<Logged out of workstation with session files open, checked server open files -files closed>> Is this terminal services or Citrix? Not exactly sure what you mean by "session". And at the end, your saying after doing this the server now sees the MDB file as closed for each of the work stations? Also, more specifics on the setup: 1. Client OS 2. Server OS 3. Network protocol(s) in use Jim (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Bartow Sent: Wednesday, August 18, 2004 6:57 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Clear Locks Via OS (was: A table that can'tbeduplicated) I just had a chance to try out some of the previous suggestions. (I haven't had a chance to check out OPLOCKS yet and I haven't downloaded PsTools yet.) I checked the file/folder permissions -check I checked the AV scanner exception list -ldb was in the exception list mdb wasn't I added that I ran the multiple applications on three workstations simultaneously and then closed them out properly, I checked the task list on each workstation -nothing listed Checked the open files on the server -ldbs were not open, mdbs were left open Returned to each workstation check processes with third party tool -nothing there Logged out of workstation with session files open, checked server open files -files closed Any other ideas? John B -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com