Permissions to allow creation of forms etc?

J

JZ

Hi,

I'm creating a database in code and setting the permissions.

I'm using the following code :-
NewDB.Users(pstrSuperUserName).SetPermissions("", adPermObjTable,
adAccessGrant, adRightReadDesign)
NewDB.Users(pstrSuperUserName).SetPermissions("", adPermObjView,
adAccessGrant, adRightReadDesign)
NewDB.Users(pstrSuperUserName).SetPermissions("", adPermObjProcedure,
adAccessGrant, adRightReadDesign)

Which works fine.

In MS Access it does everything I want execpt allow me to add buttons etc to
forms.
I get this error :-

Could not create; no modify design permission for table or query <name>.
(Error 3111)
You tried to create the specified table or query, but you do not have the
required modify design permission. To change your permission assignments,
see your system administrator or the query's creator.

What further permissions do I need to add?

Best regards,

Jules.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top