Stuart McLachlan
stuart at lexacorp.com.pg
Thu Aug 7 16:55:46 CDT 2003
On 7 Aug 2003 at 14:08, John Colby wrote: > AFAIK, JET and only JET "knows" the internals of the Access db. It creates > the lock db and it handles requests for data from an MDB from requesters > such as DAO and ADO. > > It does indeed give one pause. This is a sore point with the use of an MDB. > OTOH, can you "ask" SQL Server who is accessing a given table at the moment? > I don't have the answer to that. Yes. Just look at the Processes and Locks in Enterprise Manager. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.