Is it possible...

K

kinlye

Is it possible, depending on who is "logged in" to the Access database, for
the forms to look differently.
I mean that some of our employees don't need to see the payrates of our
employees, however, the administrative crew may see them. Is there a way to
accomplish this.
I don't really need directions on how to do it (if it's possible) just
whether Access is capable of such a thing.

Thank you in advance for your help.

J
 
T

Tony Toews

kinlye said:
Is it possible, depending on who is "logged in" to the Access database, for
the forms to look differently.
I mean that some of our employees don't need to see the payrates of our
employees, however, the administrative crew may see them. Is there a way to
accomplish this.
I don't really need directions on how to do it (if it's possible) just
whether Access is capable of such a thing.
Click to expand...

It's possible to fake it but Access is inherently not very secure.
Anyone can copy an Access MDB off the server, take it home and crack
it.

If your organization wants to ensure no one except authorized
individuals and IT administrators can see the data then they must use
SQL Server or similar.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top