DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Aug 18 12:59:59 CDT 2004
If they have 'admin' rights on the server, and the workstation is w2k, then they can open computer management on their workstation, then connect to the server with computer management, and do the same thing. However, it sounds like the VB .exe isn't really closing, otherwise, it should kill the connection when it's done. Did you make sure the .exe is truly gone from the Task Manager? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Bartow Sent: Wednesday, August 18, 2004 12:14 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Clear Locks Via OS (was: A table that can't be duplicated) This is what I am trying to do from the workstation. (I recently asked about this on DBA-Tech). I have a customer site where their 3rd party app is constantly leaving an mdb & ldb file open on the server every time they use the apps. (I can't touch the apps - VB using A97 mdb BE). I am looking for a way to do this from the workstation because as simple as it sounds, the client is afraid of logging onto the server to do this and the developer is non-responsive to the problem. (Your message below is what I have them doing now plus closing the hung mdb & ldb files for the user that is no longer using the app.) Any idea of whether I can do this from the workstation? Maybe wrap the apps startup in a batch file that calls the app and when done calls a script to clean it up? JB -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Wednesday, August 18, 2004 11:07 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Clear Locks Via OS (was: A table that can't be duplicated) Depends on the OS. You can't in Windows 9x machines, but in NT based machines, it's a matter of finding the files in use. For Windows 2000, one way to get there, is to right click on my computer, and select 'Manage'. This brings up the Computer Management screen. Expand the 'System Tools' node, then the 'Shared Folders' node, then open the 'Open Files' node. That will display all of the 'file locks' coming in from other machines. Well, sort of. It's displaying files in use, you're not going to see the individual locks that one particular user has in place. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dan Waters Sent: Tuesday, August 17, 2004 6:32 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Clear Locks Via OS (was: A table that can't be duplicated) Jim, How do you, ". . . clear the locks being held on the database file via the OS." ??? Thanks, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, August 17, 2004 11:20 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A table that can't be duplicated Paul, Delete the .LDB file if it exists, then try again. If still the same problem reboot the machine where the database resides or clear the locks being held on the database file via the OS. 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 Paul Rodgers Sent: Tuesday, August 17, 2004 11:47 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A table that can't be duplicated The main table in a database won't be copied. Access says another user is busy with the table. But this is not so. I can't copy the table and rename the table, I can't import it into another database, I can't use a MakeTable query to do it that way. I can copy the whole database, but that same table in the copied database refuses to be copied - or to be renamed. I can steal it with Excel - but then I lose all the lookups and the like. Anyone had this problem before please, anyone found an answer, please? Cheers paul -- _______________________________________________ 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 -- _______________________________________________ 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