Prevent creation of new objects

  • Thread starter Thread starter williams
  • Start date Start date
W

williams

I have created a new group which has read only rights to
all object. Is there any way that i can prevent them from
creating new objects or saving existing objects under a
new name?
 
The following code will prevent a user (or group) from creating new tables
or queries:

With DBEngine(0)(0).Containers("Tables")
.UserName = "name of user/group"
.Permissions = .Permissions And Not dbSecCreate
End With

You will also need to do this for the group "Users" as it has default
permissions to create tables.

To prevent the creation of other objects (forms, etc) you need to use an
MDE.
 
Back
Top