Overiding user msaaccess database user rights via vba code

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Aviby said:
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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top