Setting table permission via code

[Paul Doree]

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

 

[Scott McDaniel]

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.

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

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.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