[AccessD] Who is linked to my back end?

I use SQL Server 2k for the data store for my billing program.  I open the
FE, open a table directly.  I then open EM and look at the objects you
mention.  I see a lock and a process ID however I don't see any information
about the table being examined.  The lock type is DB, mode S, Status Grant,
Owner Sess.  That's all I see.

Am I missing something?  If not then SQL Server isn't overly helpful at
identifying who is in the db either.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Thursday, August 07, 2003 5:56 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Who is linked to my back end?


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.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com