Login screen

[mike30x]

Nearlly there with my DB just one last thing to-do. I hope to have multiple users accessing my DB so i was hoping to have a login screen with passwords. In addition to this is it possible to have a link to all the infromation that this person add/edits changes etc etc.

The idea being that there is an audit trail as to what infromation has been entered by any user. If anyone has a smaple of this i would aprieciate it or how i could go about doing this.

Thanks
Mike

 

[Dennisk]

you need to setup Access security (except access 2007 I believe) then you can access the name of the person currently logged on using the CurrentUser() function, whose value you can place in a field in your table along with the time/date in another field whenever the record is changed or a new record is added..

 

[mike30x]

Got the security levels set-up using the wizard and it is working great.

Is it possible to list the users at the login screen so all you have to do is select your name and type the password?

Can you explain where i can access the login infromation such as who has altered/edited a file from the security login?

Can two people be logged in at the same time on the one PC?

 

[Dennisk]

To Populate a combo box you need to develop what is called a 'callback function' where you would place your code. The good news is this is explained with examples in Access Help.

How to get the list is not clear in my book

I think you would start like this

Dim ws As workspace
dim usr as use

set ws = DBEngine.Workspaces(0)

for each use in ws.users
debug.print usr.name
next