Update Security using VB Code

[Guest]

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

 

[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.