473,320 Members | 1,713 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,320 software developers and data experts.

Detecting login users

8
Please i need to have a form where i can have the names of users who log in and log off the application.
it's important
Jun 24 '10 #1

✓ answered by patjones

@kaybaj
Well that is a much clearer explanation than your first post. Knowing all that, I would say that gershwyn's suggestion is a good way to go. Just set a table up that you do an INSERT INTO when someone logs in, and a DELETE when they log out.

The devil will be in the details though. In particular, I'm thinking of unusual circumstances like what happens when Access quits unexpectedly, or something like that.

Let us know if we can help further.

Pat

6 1463
patjones
931 Expert 512MB
You might find this how-to article of interest:

Generate secure user passwords using the MD5 hash class module

The basic idea is that you have a small form with a box for inputting username, a box for inputting password, and that you have a table in your database where you can check one against the other. The purpose of the MD5 hash is that it allows your passwords to be stored in the table in an encrypted fashion.

It's going to take some time and effort on your part to figure this out, but the basic components are there.

Pat
Jun 24 '10 #2
kaybaj
8
Thanks for that but maybe you didn't get me very well, i already have a login form that works perfectly but what i want is that since my application is going on a network of between 45-77 users, i need to be able to monitor users as they log in and log out, like a table that stores user who log in including the time of logging in and out
Jun 24 '10 #3
gershwyn
122 100+
If you already have a login form, then all you need to do is create a table to store the details you want, and have the login form run an append query whenever the user logs in or out. The Now() function will probably come in handy for supplying the time stamp.

Like Pat said, it's going to take some time and effort on your part, but we can help with specific issues you run into.
Jun 24 '10 #4
kaybaj
8
@gershwyn
thanks i'll figure out something
Jun 24 '10 #5
patjones
931 Expert 512MB
@kaybaj
Well that is a much clearer explanation than your first post. Knowing all that, I would say that gershwyn's suggestion is a good way to go. Just set a table up that you do an INSERT INTO when someone logs in, and a DELETE when they log out.

The devil will be in the details though. In particular, I'm thinking of unusual circumstances like what happens when Access quits unexpectedly, or something like that.

Let us know if we can help further.

Pat
Jun 24 '10 #6
kaybaj
8
@zepphead80
ok thanks i'll keep you posted
Jun 24 '10 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Sophia | last post by:
I need to authenticate users to enter in a NTLM-protected virtual directory, but I can't pop up a NT-login dialogue box - I can only do a web-based username/password form (my client is a...
4
by: nicholas | last post by:
Hi, Got an asp.net application and I use the "forms" authentication mode defined in the web.config file. Everything works fine. But now I would like to add a second, different login page for...
7
by: Simon Harvey | last post by:
Hi everyone, I'm having a frustrating problem and I don't know how to fix it without totally redoing a very complicated couple of pages on my site. I really hope some kind soul can help me :-) ...
9
by: Bijoy Naick | last post by:
I've implemented forms authentication and authorization on my application. In my Web.Config, my authorization section looks like this.. <authorization> <allow roles="admin" /> <deny users="*"...
1
by: alex | last post by:
Hi May i know how to do a check to find out how many users are online and logged on to our system? Btw, i am using vb.net. Perhaps show me some articles on this issue? regards Alex
18
by: Gleep | last post by:
I've searched google intensely on this topic and it seems noone really knows how to approch this. The goal I don't want clients to give out their usernames and passwords to friends, since the site...
3
by: Les Stockton | last post by:
I'm new to ASP.Net and want to take advantage of some of the new features of Framework 2.0. I've seen the Login controls and how it works with administration of security, using Windows...
2
by: Eduard Witteveen | last post by:
Dear list, In the corporation, we want to know who is using which computer, and do some phone routing based upon this information. When a user log's uses it's account to login, the phone on the...
4
by: onetitfemme | last post by:
Say, people would like to log into their hotmail, yahoo and gmail accounts and "keep an eye" on some text/part of a site .. I think something like that should be out there, since not all sites...
2
by: runner7 | last post by:
Can anyone tell me if there is a way in PHP to determine when a session times out on the server or how many concurrent sessions there are in your application?
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.