I need to restrict query results based on user-level security

  • Thread starter Thread starter justin.hribar
  • Start date Start date
J

justin.hribar

I have split my db, setup all of my workgroups, established user-level
permissions for forms, reports, etc.. Now I need to restrict the
displayed results of certain queries based on the Workgroup. As
everyone accesses the same forms (and the same queries the forms are
built from) (and I'd like to avoid building multiple forms), is there a
way I can return records based on the Workgroup? (for example, I would
like to be able to see all records, but would only like my assistant to
be able to see the other employees).

Running Access 2000


Any help would be greatly appreciated.

Thanks!
 
One more question.. In Macro builder and expression builder both.. How
do you do an If statement? There is no "If" function, and I need to
loop this through several possibilities (about 10 different workgroups)
to decide the control to enable/disable..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does one eliminate blank records on a query result? 3
Query Parameter using multiple options 0
User Level Security 6
User restrictions? 4
Using User Level Security (ULS) 6
how to pass a parameter to a query base of a query that is the base of a report 0
Query based on Check Box 1
Graph based on a Query? 4

Back
Top