MartyConnelly
martyconnelly at shaw.ca
Tue Dec 27 14:54:02 CST 2005
Someone may have set up global variable with a recordset pointing to a backend table when the database is opened It may not be cleared on close. This explains the use. Microsoft Access Performance FAQ - LDB locking which a persistent recordset connection fixes http://www.granite.ab.ca/access/performanceldblocking.htm Also see http://www.granite.ab.ca/access/corruption/workstation.htm Arthur Fuller wrote: >This box is used only by me (Administrator). A couple of directories have >been set Shared and I can see them from elsewhere but nobody has the app in >question (or its BE) open but me. That is what is so puzzling about this. >In case it should be relevant, the OS is w2003 Server and the Access is >Access 2003, both with the latest patches. >A. > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence >Sent: December 27, 2005 1:45 PM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] LDB File Left Over > >Arthur; it can not be as simple as the user does not have full access to the >directory (RWDE) where the ldb file resides? > >Jim > > > -- Marty Connelly Victoria, B.C. Canada