Overiding user msaaccess database user rights via vba code

[Guest]

Hi
1
Although CURRENT user DO NOT have read right in an msaccess database, I want my code to temporarily read/writ
a restricted linked table. How can I do it via the code assuming of course that I know the username and
password of a user who HAS full rights
2. Can I restrict read rights to a certain field ,not table, in msaccess database

thanks
aviby

 

[Joan Wild]

Hi,
1.
Although CURRENT user DO NOT have read right in an msaccess database,
I want my code to temporarily read/write a restricted linked table.
How can I do it via the code assuming of course that I know the
username and password of a user who HAS full rights.

See section 46 of the security FAQ
http://support.microsoft.com/?id=207793

2. Can I restrict read rights to a certain field ,not table, in
msaccess database.

Not directly in a table, no. You would (and should) have all data
access/editting done via forms. You could then display/enable/lock this
field depending on the user.