473,563 Members | 2,897 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 5476
TC
Check out the UserRoster thing.

HTH,
TC
"Jeff Pritchard" <je************ @asken.com.au> wrote in message
news:k8******** ********@news.o ptus.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.o ptus.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.o ptus.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.o ptus.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:<106903728 9.192167@teutho s>...
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********@hot mail.com> wrote in message
news:bf******** *************** ***@posting.goo gle.com...
"TC" <a@b.c.d> wrote in message news:<106903728 9.192167@teutho s>...
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********@hot mail.com> wrote in message
news:bf******** *************** ***@posting.goo gle.com...
"TC" <a@b.c.d> wrote in message news:<106903728 9.192167@teutho s>...
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
16260
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 example check out: http://stealthtests.lockdowncorp.com/ On that site, there are tests that will display NetBIOS & MAC addresses.
3
2574
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 I could not configure Apache myself. The REAL problem is that PHPmyAdmin works and sees my test database Wines.... But my PHP program does not!
2
2442
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 user quit with the "X" the counter will be decremented of 1 only when the Session.Timeout will be expired. Please let me know if anyone have come...
2
497
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 leaving the app running for just 6 hrs, the thread count exploded to close to 1000, before the app finally stops responding. The handles probably hit...
5
1661
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. I want to run a query that when I enter a date shows all the users that DID NOT connect for that particular day. For example, say user id's 1 and...
2
1640
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 session_start I add my application variable + 1 - in session_end I decrease application variable -1 my session timeout is 60. Then I display in the...
32
4249
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
5501
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 void Session_Start(object sender, EventArgs e) {
3
1714
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 "Find others in New York" Thanks.
0
7583
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...
0
8106
jinu1996
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...
0
7950
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6255
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5213
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3643
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...
0
3626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1200
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
924
bsmnconsultancy
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...

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.