Hide one column

  • Thread starter Thread starter Mohammad
  • Start date Start date
M

Mohammad

Hi:

I'm using office XP. I have a database that one of the
columns has information that I don't want other users to
see. Is there anyway that I can secure that column or
hide it somehow? I know that I can hide it but whoever
opens the database they can unhide it. Is there anyway I
can disable that option?? I would appreciate any comment.

thanks
mohammad
 
why don't you remove this column from the table it is in
now and then put it in a separate table an do not give
permission to no one on this table except for yourself?
Al
 
Mohammad said:
Hi:

I'm using office XP. I have a database that one of the
columns has information that I don't want other users to
see. Is there anyway that I can secure that column or
hide it somehow? I know that I can hide it but whoever
opens the database they can unhide it. Is there anyway I
can disable that option?? I would appreciate any comment.
Click to expand...


You can do this using a so-called "Run With Owner Permission" (RWOP)
query.

Make sur the table is owned *by you*. Give your users *no access at
all* to that table. Then write a RWOP query that selects all of the
columns from the table, except the one you want to hide. The RWOP
query should be owned *by you*. Then give your users access to the
RWOP query.

The result is, that your users will be able to access the query, but
they will not be able to access the table directly! The query looks
just like the table (from a functional viewpoint), but it does not
expose the column in question.

To do this properly, you will need a fairly good understanding of
"user-level security". You ** must must must ** read the "Access
Security FAQ" about 10,000 times before proceeding! Search this
newsgroup for links to that document.

HTH,
TC
 
Back
Top