How to allow rights to user via VBA?

[hanski]

Hi!

I have a tabe in my Access and I have a user. User do not have any
rights to the table so he can't even read it. But I would like to
allow him to read some information from that table. Is it possible to
create a form and give the user rights to that table via VBA code? And
when he closes the form also the rights will be discarded.

thanks.

Hanski

 

[Tom van Stiphout]

On Thu, 15 Oct 2009 00:07:33 -0700 (PDT), hanski

Presumably you used User Level Security to deny users access to the
table. If you download, study, and fully understand the Access
Security FAQ from microsoft.com, you will know that RWOP queries have
this ability.

-Tom.
Microsoft Access MVP