Create Table Rights

[Dave Ruhl]

I have created a new database in Access 2002. I used the
security wizard to setup the security file with just two
groups - Users and Admin. The Users groups has no rights
to anything, Admin has all permissions. I created a new
group with limited permissions. I have given the new
group full permissions to all tables and queries, yet
users in this group are unable to create new tables.
They get the error "Could not create; no modify design
permission for table or query 'newtable'".

If I add the user to the Admins group everything works
fine. As a test, I gave the new group full rights to
everything - identical to Admins, yet I still get the
error. Is it possible to create a group identical to
Admins, or does Admins have some rights that aren't shown
on the security forms ?

 

[Scott McDaniel]

Do they have Open Exclusive rights to the database? In 2000 and above, users
must have exclusive access to the database in order to add or modify
objects.

 

[Dave Ruhl]

The new group I created does have Open Exclusive. Do the
users in that group need to have it assigned
individually ? The new group I created has identical
settings as Admin, yet it doesn't give the same access as
Admin. Once I get it working I want my new group to have
less access than Admin, yet be able to create tables.