user notification

[virencm]

Is there a way of getting a message popup of a user who has just logged into the database??

 

[georgedwilkinson]

Yes, most definitely. Put it in the startup form or Autoexec macro.

 

[virencm]

Hi George

Thanks for the reply.. i dont understand what you mean? could you please explain in detail? thanks

viren

 

[georgedwilkinson]

In the options for the current database (how to get there depends on the version of Access you're running), you can select to display a certain form at startup or you can create a macro named Autoexec that will run when your database starts up. Inside of either, you COULD put a MsgBox() (see VBA help). If you do it in your startup form, you would put it in the "On Load" event of that form.

Sorry I'm not much of a detail person any more...it's very hard for me to pay attention to anything for very long. If you get stuck, post here with a SPECIFIC question and someone will help you out.

 

[ajetrumpet]

Is there a way of getting a message popup of a user who has just logged into the database??

if you are looking to display the user of the database or the owner of the computer, you can use the VBA code called:

application.currentuser

to show it.

 

[ajetrumpet]

Sorry I'm not much of a detail person any more...it's very hard for me to pay attention to anything for very long.

why?.........

 

[virencm]

thank you guys. appreciate it

 

[wiklendt]

Hi George

Thanks for the reply.. i dont understand what you mean? could you please explain in detail? thanks

viren

actually, i didn't understand what YOU meant? can YOU explain in detail? thanks

1) how does your user log in?

• login form with password
• login form, no password
• no login, just opening the file
• other?

2) and by saying "message popup of a user" did you mean:

• to show the user name in the subsequent forms
• alert the user to something, using their username
• alert the user to something, not really needing their username
• get the program to alert YOU when a user logs into the program
• other?

 

[virencm]

hi wiklendt

my user logs in through ms access default login form with no password. (i have used the user level security wizard to create all users)
and i want the program to alert me when a user logs into the database.

thanks in advance

 

[wiklendt]

hi wiklendt

my user logs in through ms access default login form with no password. (i have used the user level security wizard to create all users)
and i want the program to alert me when a user logs into the database.

thanks in advance

i didn't know ms access had a default login form, so i can't make any comments there. it probably (i'm guessing) uses the username from the environment, rather than a table you've defined? (i've also never used the security wizard nor used any security in my DBs, and don't know in what order things are triggered when a DB is opened/logged in) sorry.

if you want to be notified of people logging in, i presume this DB is setup over a network where each workstation then has also access to internet?

anyway, i don't think there's a way to do that natively.

you could setup some SMTP email code triggered upon login to send you a "Peter SuchandSo logged in" email, or perhaps you can alter this setup by pkstormy from dbforums to suit your setup - maybe to create a text file in the backend location instead of a FE clone. then you could have a history of who's in there too.

i've never heard of anyone wanting to do what you are doing, so i'm not sure it can be done easily. as you can see, both those methods i've suggested are rather complex.

 

[speakers_86]

I'll throw an idea in the mix. What if on login of a user, that username is added to a table (or as a variable in a macro if that is easier to program). When they logout, their name is removed from the table. When the programmer logs in, a hidden form can use the on timer event to compare the current record set with the record set from a minute ago. If the record sets are different, the programmer can be alerted to the difference via a message box.

Do you guys think this would be a good method?

 

[Khalid_Afridi]

When they logout, their name is removed from the table. When the programmer logs in, a hidden form can use the on timer event to compare the current record set with the record set from a minute ago. If the record sets are different, the programmer can be alerted to the difference via a message box.

Do you guys think this would be a good method?

Idea is not bad, but what if admin gets login and same time a user gets logout, the recordset will change definately (user is logout not login), so.... where the admin stands???

Khalid

 

[wiklendt]

Idea is not bad, but what if admin gets login and same time a user gets logout, the recordset will change definately (user is logout not login), so.... where the admin stands???

Khalid

ok, here is a question no one has asked yet.

WHY do you want to do this? maybe we can make different or more suitable suggestions depending on the purpose.

 

[wiklendt]

When they logout, their name is removed from the table.

or why not have a "login log", where instead of the user being removed from the table, a close event triggers the time and date to go into a "logged out" field in the table. so the table would have

tblUserLog
===================
LogID (PK); Autonumber
UserID (FK); Number
LogIn; Date and Time
LogOut; Date and Time

the OP can then have whateve query he wants in order to get whatever data he wants e.g., list of everyone logged in currently, or that has logged in today or for the past week, or past year, or only those still logged in... the options would be almost endless

 

[speakers_86]

That sounds better actually. Good thinking.

 

[wiklendt]

That sounds better actually. Good thinking.

maybe, but i wouldn't have come up with that without your initial suggestion team-work, yah.

 

[speakers_86]

Thats what brainstorming is all about.

 

[Khalid_Afridi]

or why not have a "login log", where instead of the user being removed from the table, a close event triggers the time and date to go into a "logged out" field in the table.

Or

Create an Administrator panel to control logged in users and their activities something like this:

 

[speakers_86]

That form must have taken some time.


edit-The OP may appreciate that db.

 

[NigelShaw]

Hi

i prefer adding users to a table. i set up a db once that had a boolean field and logged the users. when the db opened it cleared the booleans just in case a crash happened and then ticked the user to true when they logged in. Admin could then see who was on and the activity was logged. a simple query checked the users. Obviously the boolean was checked false when the user left but it gave a true user log.


Nidge