User Permission - DTPicker

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Merry Christmas! I have a database that I am attempting
to secure. I have two groups, Full Data Users, and Read
Only Users. Everything works great except that I have a
simple form with two dtpicker objects which calculates
time between dates. The Read Only users are unable to
use this form because of these two objects. Do I have to
replace them with two Calendars or is there a way to make
the dtpicker objects work?

Thanks
 
How can I give them permission on this form and have them
remain "read only" on everything else? Thanks
 
Steve said:
How can I give them permission on this form and have them
remain "read only" on everything else? Thanks
Click to expand...

By setting up User-Level security on the database. That allows control on
each object in the database. You can also hard-code and branch your code
depending upon their username to lock or unlock the controls. See the code
at:

http://www.mvps.org/access/api/api0008.htm

to get the username. The right way to do it is with User-Level security
because it will eventually become a nightmare to manage all the code
branching as the app and users change.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top