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

Keep the tables the way you have them so non-admins can't open them.  Build
queries based on these tables and make them rwop (run with owner permissions).
Use ado to open the queries, not the tables.

Chris


Harvey wrote:

Show quoteHide quote

type mismatch and allowbypasskey
.mdb file is read only...
expressions blocked inconsistently
Multi-User input and db protection
Shortcut needs to work in a Domain instead of a workgroup
Access cannot open file on stand alone computer
I cannot open a DB created by another user on my PC.
help understanding mdw files!
AllowBypassKey and Type Mismatch Error
How to Prevent Editing a Database?