user logging system

[GraemeG]

Hello,

I have a form which runs before the database opens which is basically a login screen.

It is a username and password system. Based upon a table called Users.

I was wondering if there was something to log when a user has been in and what they have been looking at I.e tables and forms reports etc and what date and time.
Also is this possible to extract itself every week then refresh the log?

Thanks

 

[DCrake]

I placed a demo on the sample databases section that records the login sessions for individual users. It does not delve into what they did whilst logged in as this is different for each individual application. But is does tell me when they logged in and at what time and from what machine.

Take a look at this link.

 

[GraemeG]

I placed a demo on the sample databases section that records the login sessions for individual users. It does not delve into what they did whilst logged in as this is different for each individual application. But is does tell me when they logged in and at what time and from what machine.

Take a look at this link.

Thanks currently at work and cannot look at that link. But will do tonight. Thanks.

 

[GraemeG]

Thanks!
That is exactly what I am after. Just need to study it and transfer it to my database.

However just a few questions. I notice you have a tbl permissions and in there is has an access level, what does that relate to and what can that function bring, because I think it is something I would like to incorporate.

 

[DCrake]

The access levels can determine what they can and can't do.
Admin, Power User, Guest, Etc

 

[GraemeG]

The access levels can determine what they can and can't do.
Admin, Power User, Guest, Etc

Cheers got the logging system all set up with my users now. Great stuff!!

How do you dertermine, or should I say setup the user levels?
Is this something built into MS Access or some VBA needs writing?

 

[DCrake]

You may not want certain users to delete records or print certain reports or change certain data items. By testing their user level prior to running a report, etc you can deny them access. Also lets say you have lookup tables and they enter a selection that is not in the list, you may not want them to add items willy nillly again this can be controlled using access rights and permissions.

 

[GraemeG]

You may not want certain users to delete records or print certain reports or change certain data items. By testing their user level prior to running a report, etc you can deny them access. Also lets say you have lookup tables and they enter a selection that is not in the list, you may not want them to add items willy nillly again this can be controlled using access rights and permissions.

Hi, yes. I dont quite understand though how you get to endorse these userlevels.

 

[GraemeG]

DCrake:
Is there a way to add a change password option to the login screen?
I have done few attempts but I dont fully understand all the code written.
Help would be much appreciated.

 

[DCrake]

That facility is already in place, just read the code and comments made inside the module.

 

[GraemeG]

That facility is already in place, just read the code and comments made inside the module.

Sorry yes I see that. But isnt that the new password option that appears if there is not a password in place?
I wanted it so that the user can change the password whenever they wanted via an option on the login screen.

 

[DCrake]

You would have to add that functionality yourself. Normally you would have a setting that allows the user to change their own password, or that passwords expire after so many days. If you want users to be able to change their own passwords then you need add it yourself as I said earlier. This is just a demo.

 

[GraemeG]

DCRAKE HELP ME PLEASE!

I have installed my database on the handhelds (Archos 9 Windows 7 Starter)
Lots have errors are occuring with the login system.
Straightaway from the login screen as soon as you select a username it debugs.
"Compile Error - Can't find project or library"
and highlights Private Sub CboUser_Afterupdate() and points to the first use of .CboUser

I cannot log in this way and have to go round the back. Then I have noticed it also wont log times etc But when I try to open the FrmSessions it says function not available in expressions in query expressions 'Format([FldLoginEvent],"ddd -mmm dd, yyy at h:nn am/pm".

 

[DCrake]

Take a look at the tools and references to see if you have any missing references, such as DAO object library.

What install path have you used for the hand helds?

 

[GraemeG]

Take a look at the tools and references to see if you have any missing references, such as DAO object library.

What install path have you used for the hand helds?

On the Archos Tools>References.. is greyed out.
Also I have only installed it to desktop on the archos for now just for testing.

 

[DCrake]

Forgive my ignorance but what is a Archos?

What extension have you installed?
How did you install it?
Is it runtime?

 

[GraemeG]

Forgive my ignorance but what is a Archos?

What extension have you installed?
How did you install it?
Is it runtime?

http://www.archos.com/products/tw/archos_9/index.html?country=us&lang=en

Extension - sorry not sure what this is.
I have not used the setup file to install as of yet. (When I have fully complete the aim is to package it up and install it into the Users folder as per the default on the setup along in the package is Runtime also)

For the testing at the moment I have literally just placed the whole database onto the desktop of the Archos and opened it using Access 2007 (not runtime)

 

[DCrake]

So you have full blown Access 2007 on your tablet. you copied the application direct to the desktop

Did you set up the Trusted location correctly on the tablet?

Also I suspect with W7 it may not like running apps from the desktop I would put in a a sub folder of C:\ and make it a trusted location

 

[GraemeG]

So you have full blown Access 2007 on your tablet. you copied the application direct to the desktop

Did you set up the Trusted location correctly on the tablet?

Also I suspect with W7 it may not like running apps from the desktop I would put in a a sub folder of C:\ and make it a trusted location

Not sure what a trusted location is?
Yeah access 07 full with developer exts.
i have just placed AcroPdf.dll into the Archos system 32 folder and it works now. Logs in and logs times etc. Not sure what else it might throw up now though. it has also ungreyed References and there are a few ticked in there now.