Logon

[Guest]

Hello

Is there anyway on access i can create a logon to a databse so i can track
who logs on and at what time? if there is how would i go about this?

Regards

 

[Guest]

Check this link on "Access Database Security - Steps to Securing an Access
Database by Using User-level Security"

http://www.databasedev.co.uk/access_security.html

 

[Vayse]

Well, if you have a secured database, you could store the the user logon in
your opening form.

Lets say your opening form is a Switchboard.
You could create a Logon table with 3 fields, LogonId (autonumber) ,
UserName and logonTime.
Then in the Open event of your switchboard, have something like this

Dim rsLogons as DAO.recordset
Set rsLogons = CurrentDb.Openrecordset("Logon")
With rsLogons
.Addnew
!UserName = CurrentUser()
!LogonTime = Now()
.Update
.Close
End With

Hope this helps
Regards
Diarmuid

 

[Pieter Wijnen]

or you can use the name of the Currently logged on user
check www.mvps.org/Access (API section) for the neccessary code

Pieter

 

[Pieter Wijnen]

or you can use the name of the Currently logged on user
check www.mvps.org/Access (API section) for the neccessary code

Pieter

Well, if you have a secured database, you could store the the user logon
in your opening form.

Lets say your opening form is a Switchboard.
You could create a Logon table with 3 fields, LogonId (autonumber) ,
UserName and logonTime.
Then in the Open event of your switchboard, have something like this

Dim rsLogons as DAO.recordset
Set rsLogons = CurrentDb.Openrecordset("Logon")
With rsLogons
.Addnew
!UserName = CurrentUser()
!LogonTime = Now()
.Update
.Close
End With

Hope this helps
Regards
Diarmuid

--