Security

[NeoFax99]

I would like to be able to have my database use the users login to
allow access to certain features in the database. Is there a website
that explains how to do this other than using a *.mdw file?

 

[Graham R Seach]

You have to code it yourself.

Use the following to get the user's domain username, and then add code (at
form level) to handle access control.
http://www.pacificdb.com.au/MVP/Code/GetLoginName.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[NeoFax99]

Thanks for the help!

You have to code it yourself.

Use the following to get the user's domain username, and then add code (at
form level) to handle access control.
http://www.pacificdb.com.au/MVP/Code/GetLoginName.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[NeoFax99]

OK, now that I have this working and can trap the username, how would I
setup a form that allows only certain people capability to see certain
checkboxes and buttons to delete data from the database? Thanks!