Setting table permission via code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Doree - 24 Jun 2007 08:15 GMT

Hi,

I need to create a new level of user access in a databse I have written. I
could go to thier site to set the permissions on the back end tables, but it
would be far more prefereble to have the front end run code on startup to do
this. I have no problems with setting the code to run on startup, but after
looking throught the help files haven't managed to find any examples of how
to programatically set permissions.

Can anyone give me some pointers/examples?

Paul

Reply to this Message

Scott McDaniel - 26 Jun 2007 14:06 GMT

>Hi,
>
[quoted text clipped - 4 lines]
>looking throught the help files haven't managed to find any examples of how
>to programatically set permissions.

The FAQ has some code examples which may be of use:

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fs
ecfaq.asp

Topic 37 might be of particular interest.

Hope that URL works; in the past, I've had it go away at times. This mentions 2000, but is valid for all newer version
of Access as well (except 2007 with the ACCDB format, which doesn't support ULS any longer).

>Can anyone give me some pointers/examples?
>
>Paul

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message