My boss wants different access rights for employees in my database, so they
can only access their work, but so that he can access all the work. Please
help

"melly66" <(E-Mail Removed)> wrote in message
news:E3BD927A-AD90-4D60-A48B-(E-Mail Removed)...
> My boss wants different access rights for employees in my database, so
> they
> can only access their work, but so that he can access all the work.
> Please
> help

That's a tall order if you are a beginner. The place to start is the FAQ on
security, there's a link to it on my web site. Be ready for a steep
learning curve and to get things wrong ... and to start tearing your hair
out! Oh and always back up your files before attempting to apply security
in case you lock yourself out.

Regards,
Keith.
www.keithwilby.com

Once you implement User-Level security, and take away all access to the
tables, you will most likely want to build two forms. One will have access
to all records and will only be available to your bos. The other will be
based on a query that only allows access to the current user's records.
This would be done by putting criteria in the query under the "userid"
column for the record. The criteria would be =CurrentUser()

Since the users won't have access to the tables (that would let them get
around your security) you will have to set this query to "run with owner's
permissions".


--
Rick B



"melly66" <(E-Mail Removed)> wrote in message
news:E3BD927A-AD90-4D60-A48B-(E-Mail Removed)...
> My boss wants different access rights for employees in my database, so
they
> can only access their work, but so that he can access all the work.
Please
> help