Changing table permissions in VB Code?

[Jozef]

Hello,

Is there a way to change table permissions in VB Code? I can't seem to find
much that's concise in the help file. Here's the situation;

I have a table in the "data" portion of a split database. The table is a
list of values that shouldn't be accidentally changed by the user, so I've
taken the administer and delete permissions off. I'm using the regular
workgroup file, with the default Admin user name, so there is no funky
permissions set up. If a user knew how to use the permissions, and wanted
to, he/ she could put the administer permissions back on the table and
change what they wanted to.

What I'm trying to do is this; I need to add a field to the table, but in
order to do so, I need to add the Administer permissions back in, add the
filed, then remove the Administer permission. Can I do this in code? The
database is on the other side of the country, so I can't be on site to
update it.

Thanks!

[David Lloyd]

Jozef:

The Access security model is available through DAO. You could
programmaticall y iterate through all users and groups, and their appropriate
permissions on each database object. You could store the results to a table
or text file.

F. Scott Barker's "Microsoft Access 2000 Power Programming" has an excellent
chapter on how to programmaticall y access the security features of Access.
(There may be a newer edition of this book).

An example would be the following:

Dim db as Database
Dim con as Container
Dim doc as Document

Set db = CurrentDb
Set con = db.Containers(" Tables")
Set doc = con.Documents(" MyTable")

doc.UserName = "Admin"

Debug.Print doc.AllPermissi ons
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Jozef" <[e-mail]> wrote in message
news:MkIYe.5415 69$s54.405494@p d7tw2no...
Hello,

Is there a way to change table permissions in VB Code? I can't seem to find
much that's concise in the help file. Here's the situation;

I have a table in the "data" portion of a split database. The table is a
list of values that shouldn't be accidentally changed by the user, so I've
taken the administer and delete permissions off. I'm using the regular
workgroup file, with the default Admin user name, so there is no funky
permissions set up. If a user knew how to use the permissions, and wanted
to, he/ she could put the administer permissions back on the table and
change what they wanted to.

What I'm trying to do is this; I need to add a field to the table, but in
order to do so, I need to add the Administer permissions back in, add the
filed, then remove the Administer permission. Can I do this in code? The
database is on the other side of the country, so I can't be on site to
update it.

Thanks!

[Jozef]

Thanks David I'll bark up that tree.

You mentioned that you could tell what permissions are on the table, but can
you modify those permissions through code?

Thanks!

"David Lloyd" <Da***@NoSpamPl ease.com> wrote in message
news:rI******** *******@bignews 6.bellsouth.net ...

Jozef:

The Access security model is available through DAO. You could
programmaticall y iterate through all users and groups, and their
appropriate
permissions on each database object. You could store the results to a
table
or text file.

F. Scott Barker's "Microsoft Access 2000 Power Programming" has an
excellent
chapter on how to programmaticall y access the security features of Access.
(There may be a newer edition of this book).

An example would be the following:

Dim db as Database
Dim con as Container
Dim doc as Document

Set db = CurrentDb
Set con = db.Containers(" Tables")
Set doc = con.Documents(" MyTable")

doc.UserName = "Admin"

Debug.Print doc.AllPermissi ons
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or
warranties.
"Jozef" <[e-mail]> wrote in message
news:MkIYe.5415 69$s54.405494@p d7tw2no...
Hello,

Is there a way to change table permissions in VB Code? I can't seem to
find
much that's concise in the help file. Here's the situation;

I have a table in the "data" portion of a split database. The table is a
list of values that shouldn't be accidentally changed by the user, so I've
taken the administer and delete permissions off. I'm using the regular
workgroup file, with the default Admin user name, so there is no funky
permissions set up. If a user knew how to use the permissions, and wanted
to, he/ she could put the administer permissions back on the table and
change what they wanted to.

What I'm trying to do is this; I need to add a field to the table, but in
order to do so, I need to add the Administer permissions back in, add the
filed, then remove the Administer permission. Can I do this in code? The
database is on the other side of the country, so I can't be on site to
update it.

Thanks!