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!