Password / Login 1

[jbento]

I would like to create a way for a user to login and use a password for their particular record in the database. Could I make a user table with an ID field that is associated with their record, and create a login / password prompt for that? Does anyone know how I could go about doing this? Is their easy code for this? Please help. Thanks.

 

[gyli84]

Can the code check the currentuser after workgroups and user level security is implemented and open an appropriate form upon entry (say a manager's console or another one for just a normal user). Also is there a way of getting it to display the name of the user on that opening form (there would be no relationship between the User ID in the workgroup file and the user's name as there is no user name field in the workgroup file).

 

[GBall]

You could modify the table and user maintenance form to hold the user's name.
Set the logon code to bypass the logon screen if the user has already looged on (e.g. NT), but still access the table to pick up those details.

 

[amal1973]

Please write the code ... i have been tring to find a way to limit user access for some time now....
i think the current user will do the trick ...
thanks
amal

 

[GBall]

if you are using Access security already, I suggest you look at the following thread where AiVars has posted a solution.
regards
Graham

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/705/qid/120248