Update Security using VB Code

24 Oct 2007 9:03 AM

neil_D

I have a database that uses user level security,
Certain tables have been allocated Read-Only access, by changing the group
security.
Unfortunately, the <New Tables/Queries> item in the 'MyUser' Group has no
privilages.
I Know I can modify the <New Tables /Queries> Security group from within MS
Access, but Is it possible to Modify the <New Tables/Queries> security
permissions for this group, so that they can create tables using Visual Basic
6, as long as I can connect to the database as admin?

Any help would be greatly appreciated

24 Oct 2007 6:24 PM

Joan Wild

Permissions on <New Tables/Queries> don't affect a user's ability to create new tables/queries. The permissions just dictate what permissions they'll have on newly created objects.

If they create a new object, they'll have full permissions since they'll own the object.

If you need to have a group of users be able to create new tables, reconsider your approach. It's unusual to need to create new tables like this.

Perhaps run a delete query, followed by an append query instead.

--
Joan Wild
Microsoft Access MVP

Show quoteHide quote

"neil_D" <nei***@discussions.microsoft.com> wrote in message news:A3620ED8-F313-4CFC-B268-B76DB645AEFF@microsoft.com...
>I have a database that uses user level security,
> Certain tables have been allocated Read-Only access, by changing the group
> security.
> Unfortunately, the <New Tables/Queries> item in the 'MyUser' Group has no
> privilages.
> I Know I can modify the <New Tables /Queries> Security group from within MS
> Access, but Is it possible to Modify the <New Tables/Queries> security
> permissions for this group, so that they can create tables using Visual Basic
> 6, as long as I can connect to the database as admin?
>
> Any help would be greatly appreciated
>
>