[AccessD] Number of Users

Jim Dettman jimdettman at verizon.net
Mon Jan 7 04:54:40 CST 2008



  Microsoft started calling the ability to get the list of users the "user
roster" when they came out with the OLEDB driver for JET 4.0.

  Prior to that, for A97 and A95 (JET 3.x), one used the functions in the
DLL MSLDBUSR to get the user list.  Before A95 (JET 2.x and 1.x), there was
no easy way programmatically to determine who was attached to the database
file.

  Most programmers simply parsed the .LDB file, which was not accurate on
its own.  To determine who is actively attached to a database, you need to
check the LDB file, the database header page, and the user locks currently
held.  Microsoft had a utility called LDB Viewer which did that, but you
could not work with it programmatically. 

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, January 06, 2008 6:26 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Number of Users

What is the Roster function? I haven't heard of it before.

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




More information about the AccessD mailing list