DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Aug 18 11:06:39 CDT 2004
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