H
Harvey
Hello:
We have an Access 2003 application. I am trying to prevent users from
seeing uid/pwd in a small table I created (Access 2003). So in the
user-level security wizard, I deselected all db objects and selected only
this table. In the next screen, I chose, "yes, I would like to grant some
permissions to the User group". I deseelcted all permissions on the Table
tab (read, update, etc.) and on the query tab, selected read/read design(it
makes you choose both). Because my app uses ADO to read from this table, I
thought this would be the way to set permissions.
However, when I run the application starts up and attempts to read from this
table using the ADO query, I get, "Record(s) cannot be read, no read
permission on <tablename>".
Could anyone tell me how to hide this table from users, while still allowing
the program itself to read from the table?
thank you in advance for any advice.
Regards
Harvey
We have an Access 2003 application. I am trying to prevent users from
seeing uid/pwd in a small table I created (Access 2003). So in the
user-level security wizard, I deselected all db objects and selected only
this table. In the next screen, I chose, "yes, I would like to grant some
permissions to the User group". I deseelcted all permissions on the Table
tab (read, update, etc.) and on the query tab, selected read/read design(it
makes you choose both). Because my app uses ADO to read from this table, I
thought this would be the way to set permissions.
However, when I run the application starts up and attempts to read from this
table using the ADO query, I get, "Record(s) cannot be read, no read
permission on <tablename>".
Could anyone tell me how to hide this table from users, while still allowing
the program itself to read from the table?
thank you in advance for any advice.
Regards
Harvey