Securing tables

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

Guest

I have recently secured all objects throughout an Access 2000 database. I have given zero permissions to groups and users on all tables and restricted access to tables through the use of queries set "run with owners permission." Everything works great, however, there is massive code running behind the forms and I keep getting messages stating "no read permissions for the X table."

My question: How do I effectively set security on tables with code running behind the forms demanding access to tables? Modules w/permissions?
 
Shu said:
I have recently secured all objects throughout an Access 2000 database. I
Click to expand...
have given zero permissions to groups and users on all tables and
restricted access to tables through the use of queries set "run with owners
permission." Everything works great, however, there is massive code running
behind the forms and I keep getting messages stating "no read permissions
for the X table."
My question: How do I effectively set security on tables with code
Click to expand...
running behind the forms demanding access to tables? Modules w/permissions?

Have your code access the RWOP queries instead of the tables.
 
Rick's advice "Have your code access the RWOP queries instead of the tables."

Worked! Thank you very much. In place of table X in the code, I replaced with qryX in the code.
 
Back
Top