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
3  4678 
Hi, MX*****@gmail.c om wrote:
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?
You could try the "Network-Monitor" to see whether you get more exact
informations: http://www.resources.intuidev.com/
Regards
Jens
Thanks Jens. I should have made clear ... we have an Access 97 runtime
app that is in production use in many sites around the world. I am
investigating code that will allow the app to accurately determine the
number of users at runtime. We do have some code that does this
without using MSLDBUSR.DLL. However MSLDBUSR.DLL seems to be popular
in this group, so I thought it would be worth a look.
Jennifer
<MX*****@gmail. comschreef in bericht news:11******** **************@ x40g2000prg.goo glegroups.com.. .
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
If I remember well the count is correct *when* you open the db from which you do the counting.
So close *your* db and open again. Is the count correct at *that* time ??
Arno R This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to from
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is...
|
by: Pat |
last post by:
Hello,
Two questions - hence the weird subject.
First, anyone had luck with the Enumerating user accounts in a NT Domain
module by Dev Ashish on Access Web
(http://www.mvps.org/access/api/api0058.htm). I get "true" as the only
return.
Also, I am developing my first split database - BE to reside on a file
server and the FE to be...
|
by: NB |
last post by:
Hi
I have been developing on MS Access / Jet / VBA platform for about 2
years.
The current project I am working on for a small business is built on
Access 2002. It has about 53 tables in 2 backend MDB files, 125
queries, 109 forms & subforms, 43 reports & subreports, 20 code
modules and some macros.
The size of the backend is now at a...
|
by: Ian |
last post by:
Using Access 97 I want to distribute my database over a LAN but limit the
number of PC's that can use it at the same time. Perhaps limit it to 3 so
when the 4th user tries to open it they cant until one of the others closes
the database. I have seen other application that do this according to the
number of users that are licensed for it.
I...
|
by: swapna_munukoti |
last post by:
Hi all,
Is msldbusr.dll distributable?
Thanks & regards,
Swapna.
| | |
by: Les Desser |
last post by:
I know that the .ldb file should show the users currently logged into a
database.
However, when a user logs out I cannot detect any change in the file.
I must be missing something as PSPad pops up a message that the file has
changed (maybe it is just detecting the time-stamp but that means
something **has** changed)
However, when I...
|
by: teddysnips |
last post by:
One of my clients has asked me to make a change to one of their Access
applications.
The application is a Front End/Back End standard app. I didn't
develop it, but looking at it tells me that it was done entirely using
the Wizards. There is no log-in procedure.
They want to amend it so that only one person can be logged in at any
one...
|
by: John |
last post by:
We have an mdb for about 5 users. They don't have to log in to get into the
mdb, they just open it. However, sometimes we need to make sure no one is in
the mdb. From the ldb we then see that some one is in the database. Is there
some way to find out which user in still in the mdb?
Thanks,
john
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
