Hiding an Object by help of password

  • Thread starter Thread starter shriil
  • Start date Start date
S

shriil

Is it possible to hide an object like a table, which can only be unhid
by a password. Any codes for this? Would be helpful for me as I have a
user-level security database, where the user may have permission for
updating and inserting data into a table by help of different queries,
but will not be able to see the table in which he is updating.
 
Hi.
Would be helpful for me as I have a
user-level security database, where the user may have permission for
updating and inserting data into a table by help of different queries,
but will not be able to see the table in which he is updating.
Click to expand...

As suggested, implementing User-Level Security with RWOP queries will prevent
the user from opening or importing the table, yet allow the user to update and
add data to that table. Please see the following Web page for downloading the
Security FAQ on how to accomplish this:

http://support.microsoft.com/?id=207793

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Back
Top