Create Security

  • Thread starter Thread starter Antonio Bustamante
  • Start date Start date
A

Antonio Bustamante

Can you help me.
Some body have a presentation or a document that explain
step to step how can I put a users and passwords to a form?
if have an images is best.

I like to learn how can do it whit the user's
system/network username, I see one example in
http://www.mvps.org/access/api/api0008.htm
and a create a new module with the information that this
page have and I don`t know what need more to do for this
start in accion or how can union with the form or if I
need to give some configuration to the mdb.

I really apreciate you help
 
Create a table of users
tblUsers
UserID
UserName
UserPwd
UserPermission

When the user starts the app, retrieve their login name. Show a login form
that prompts for their password. Authenticate as needed.

Open the main menu. Based on the user's permission, dictate what buttons on
the form they can use(Set the enabled property to true or false), which will
correspond to the forms that could be opened throughout the application.

No pictures available at this time.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thanks very much
-----Original Message-----
Create a table of users
tblUsers
UserID
UserName
UserPwd
UserPermission

When the user starts the app, retrieve their login name. Show a login form
that prompts for their password. Authenticate as needed.

Open the main menu. Based on the user's permission, dictate what buttons on
the form they can use(Set the enabled property to true or false), which will
correspond to the forms that could be opened throughout the application.

No pictures available at this time.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

"Antonio Bustamante"


.
 
Back
Top