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