Permissons help

[Guest]

I need to prevent users from seeing the full data in the tables, and only
restrict them to what can be shown in queries.

i have the setup as follows:
admin group with 1 user
full data group with n users

the full data group has NO permissions on the tables, but only the required
permissons on queries (read design, read data, update data, insert data,
delete data) and forms/reports/macros (open/run).

I have set the run permission in the query properties to Owners for all
queries, however when i load the database as a user in the full data group, i
get the message: "Record(s) cannot be read; no read permission on
'objective_Individ'.

I understand that its telling me the user is not allowed to read the table,
but the query is set as run with owners permissions. If i allow the users to
read the table, then they can open it and see all the data.

Thanks for any and all help
ben

 

[Guest]

Sorry. I just figured it out. The forms had recordsources set through the
gui, that get changed on the OnLoad event. I had forgotten to remove those
ealier and thought i had.

Thanks anyways.

 

[Keith Wilby]

I need to prevent users from seeing the full data in the tables, and only
restrict them to what can be shown in queries.

i have the setup as follows:
admin group with 1 user
full data group with n users

the full data group has NO permissions on the tables, but only the
required
permissons on queries (read design, read data, update data, insert data,
delete data) and forms/reports/macros (open/run).

I have set the run permission in the query properties to Owners for all
queries, however when i load the database as a user in the full data
group, i
get the message: "Record(s) cannot be read; no read permission on
'objective_Individ'.

I understand that its telling me the user is not allowed to read the
table,
but the query is set as run with owners permissions. If i allow the users
to
read the table, then they can open it and see all the data.

Thanks for any and all help
ben

Is any code or macro referencing the table?

Keith.
www.keithwilby.com

 

[Guest]

the code wasnt, but the gui was. the code reset all recordsets, and i had
thought i had cleared that out earlier.

thanks for the responce

 

[Guest]

the code wasnt, but the gui was. the code reset all recordsets, and i had
thought i had cleared that out earlier.

thanks for the responce