can you use action queries with user-level security

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,


I fail to see the relation between queries and user-implemented security,
except that you can run the query with the USER set of permissions, or with
the query owner's set of permissions (add WITH OWNERACCESS OPTION at the
end of the query text) as credentials.



Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

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

Protect Queries 1
Re: Requery after you modify the SQL statement in VBA Access? 1
Query to change record based on calculation 3
Run an action query based on information in a form 2
Query with count, but what am I counting?! 4
Distinct not working in 2007 as in 2003 7
Query Criteria Not Working 2
Disable Pop Up Box 4

Back
Top