MSLDBUSR.DLL

Microsoft Article ID : 166938 How To Find Users Connected to an Access
7.0 Database gives some sample code which calls MSLDBUSR.DLL.

In my own testing, this code correctly increments the user count as
additional instances of the app are opened. However it continues to
return the count of the maximum users even after instances are closed.

For example; in my testing I use MyDB.mdb. If I open a second instance
of MyDB.mdb, the user count returned is 2. If a third instance is
opened, the user count is 3. However, if one of those instances is
closed, the user count remains 3. In fact, it continues to return a
user count of 3 untill all instances are closed and the ldb file is
destroyed.

I need to access the current user count. Can anyone shed any light?


Kind Regards

Jennifer

.

Relevant Pages

  • Re: Converting Access 2000 back to 97
    ... Access 2000+, and recent versions of SQL Server, normally use ... and if any of your tables use nVarChar fields ... On the other hand, if this is a old database, using VarChar ... The sample code often demonstrates linking CurrentDB, ...
    (microsoft.public.access.conversion)
  • Re: Registering programs in access
    ... It worked fine for me with no changes to the sample code. ... 'Create text string containing "Database to Call". ... >> (no private e-mails, please) ...
    (microsoft.public.access.conversion)
  • Re: Create Site: The specified domain either does not exist or could not be contacted.
    ... I specified email server settings again which succeeded. ... if I use the complete sample code for extending a vs: ... Database 'sts_content' already exists. ... After you create a new configuration database, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: updating front end
    ... perhaps ReconnectTables() returns false - try to check this ... >i have gotten a sample code from ... > doesn't match then it will automatically updates the fe database on each ... > tblversionclient and tblversionserver does exist but the msbox pop ups. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Link to a new table location
    ... There's sample code at "The Access Web" in ... as it's only set up to handle all tables being in the same database. ... "Beth" wrote in message ...
    (microsoft.public.access.tablesdbdesign)