Setting table permission via code

  • Thread starter Thread starter Paul Doree
  • Start date Start date
P

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

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

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