Access 2003 security

Guest · Dec 2, 2005

Is it possible to have reports accessible to people only by entering their
name or Id and then a password?

How would this be done?

We have 60 sales reps who need to see their yeartodate sales figures, but we
don't want them look at other reps figures.

Thanks

Jeff Conrad · Dec 2, 2005

Access User Level Security will provide the *best* security for you, but if you just need something
simple for a single form and/or report you could try these Microsoft KB articles:

http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

Access 2003 security

Guest

Jeff Conrad