User-level security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
How can I limit user's access to the tables, I don't want the users to be
able to open, even in read-only mode, or create a new one but because my
forms are related to the table they should be able to oull up the data from
tables in forms format.
I tried to use user and group permission option in the security but when I
don't let them to open and run the tables access doesn't let user to retrieve
data out of those tables,
please advice.
Ramtin
 
You can use RWOP (run with owner permission) queries for all data
interaction. Using these, your users don't need any permissions on the
tables. You set this property in the properties dialog for a query while in
design view.

Read more at www.jmwild.com/RWOP.htm
 
Back
Top