473,394 Members | 2,090 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Getting count of connected users

I need to get a count only of the number of users currently connected to a
back-end mdb when a front-end is opened. This is for 2000 onwards.

Preferably without requiring any special references or activex files.

Can anyone help.

Jeff
Nov 12 '05 #1
7 5456
TC
Check out the UserRoster thing.

HTH,
TC
"Jeff Pritchard" <je************@asken.com.au> wrote in message
news:k8****************@news.optus.net.au...
I need to get a count only of the number of users currently connected to a
back-end mdb when a front-end is opened. This is for 2000 onwards.

Preferably without requiring any special references or activex files.

Can anyone help.

Jeff

Nov 12 '05 #2
Thought about that but it requires a reference to Microsoft ActiveX Data
Objects 2.x Library.

My concern about this is that I want to distribute the database and I am not
sure if this component will always be installed and if the reference will be
maintained.

Jeff

"TC" <a@b.c.d> wrote in message news:1069033578.356889@teuthos...
Check out the UserRoster thing.

HTH,
TC
"Jeff Pritchard" <je************@asken.com.au> wrote in message
news:k8****************@news.optus.net.au...
I need to get a count only of the number of users currently connected to a back-end mdb when a front-end is opened. This is for 2000 onwards.

Preferably without requiring any special references or activex files.

Can anyone help.

Jeff


Nov 12 '05 #3
TC
Isn't that "ADO"?

I assumed that a "2000 onwards" db would always have ADO available.

Yes? No?

TC
"Jeff Pritchard" <je************@asken.com.au> wrote in message
news:%p****************@news.optus.net.au...
Thought about that but it requires a reference to Microsoft ActiveX Data
Objects 2.x Library.

My concern about this is that I want to distribute the database and I am not sure if this component will always be installed and if the reference will be maintained.

Jeff

"TC" <a@b.c.d> wrote in message news:1069033578.356889@teuthos...
Check out the UserRoster thing.

HTH,
TC
"Jeff Pritchard" <je************@asken.com.au> wrote in message
news:k8****************@news.optus.net.au...
I need to get a count only of the number of users currently connected
to
a back-end mdb when a front-end is opened. This is for 2000 onwards.

Preferably without requiring any special references or activex files.

Can anyone help.

Jeff



Nov 12 '05 #4
"Jeff Pritchard" <je************@asken.com.au> wrote in message news:<k8****************@news.optus.net.au>...
I need to get a count only of the number of users currently connected to a
back-end mdb when a front-end is opened. This is for 2000 onwards.

Preferably without requiring any special references or activex files.

Can anyone help.

Jeff


Jeff,
How about:
http://support.microsoft.com/default...B;en-us;198755

uses ADO.
Nov 12 '05 #5
"TC" <a@b.c.d> wrote in message news:<1069037289.192167@teuthos>...
Isn't that "ADO"?

I assumed that a "2000 onwards" db would always have ADO available.

Yes. Built that way. I asked if I could make DAO the default in
2000, and MichKa said "No. That's the way it was written. ADO is now
the default. Learn to like it."

Well, it's available unless someone specifically unregisters the
library, but then in Win2000+, I think it's part of the OS.
Nov 12 '05 #6
Sounds good. Can't stop anyone from doing that and I don't think that is a
big problem.

I want to use this to determine how many users are logging in to a database
for licensing mainly. However, a client has also asked if I can provide a
simple form listing who is logged in at any time. This sounds like the
perfect answer.

I will do some tests.

Jeff

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"TC" <a@b.c.d> wrote in message news:<1069037289.192167@teuthos>...
Isn't that "ADO"?

I assumed that a "2000 onwards" db would always have ADO available.

Yes. Built that way. I asked if I could make DAO the default in
2000, and MichKa said "No. That's the way it was written. ADO is now
the default. Learn to like it."

Well, it's available unless someone specifically unregisters the
library, but then in Win2000+, I think it's part of the OS.

Nov 12 '05 #7
TC

"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"TC" <a@b.c.d> wrote in message news:<1069037289.192167@teuthos>...
Isn't that "ADO"?

I assumed that a "2000 onwards" db would always have ADO available.
Yes. Built that way. I asked if I could make DAO the default in
2000, and MichKa said "No. That's the way it was written. ADO is now
the default. Learn to like it."
That just means that ADO is the default reference when you create a new
database (in A2k). But you can easily create a new database, then change the
default ADO reference, to whatever you want: ADO, DAO, or both, in either
order.

Anyway, if you >have< learned to like ADO, you can just use the userroster
thing, no?

HTH,
TC

Well, it's available unless someone specifically unregisters the
library, but then in Win2000+, I think it's part of the OS.

Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Snuffy2 | last post by:
I'm looking to try to get a users MAC and/or NetBIOS name when they visit my website. It somehow can be done, I'm not sure with PHP, but it can be done. Does anyone have any idea how? As an...
3
by: James | last post by:
Please help - getting very desperate! Sun, 12 October 2003 05:39 I have PHPDEV 4.2.3 from Firepages.com.au as the upgrade to 4.3.0 did not work. I also had an abortive download from PHP.NET as...
2
by: Daniel L. | last post by:
Hi, I've searched over 1 hour on Google and elsewhere and haven't found anything. I'd like to find a way to get the real active user count on our website. THe main problem I have is when a...
2
by: brendonlam | last post by:
Hi there, Hoping someone could advise me here pls; I'm creating a C# class that implements a telnet client socket allowing a VB . NET application to communicate with telnet servers. After...
5
by: Andy Davis | last post by:
I have a two tables, Users and Requests, the latter which displays the daily log on's of 20 users. Both tables are related by a one-to-many relationship in the Requests table via the UserId field....
2
by: xisco | last post by:
hi all, I am counting the number of users logged in my website. That's how I do in my global.asax (asp.net 2.0) - in my application_start I initialize an application variable with 0; - in...
32
by: Ciaran | last post by:
Hi I've seen this a few places - The site lists off the number of people (not logged in) currently browsing the site. How can I do this with php / mySQL please?
4
by: tim007 | last post by:
Hi, How can we get tthe number of active users connected to our web application. I have added application varible that gets incrimeted at session_start and then is decreased at session_end ...
3
by: rpupkin77 | last post by:
Hey, How does one going about their user's geographical location? Is that even a PHP question. For example, a site may say "Find others near Boston", but if you were in New York, it would say...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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...
0
Oralloy
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,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.