Re: Permissions to allow creation of forms etc?

"JZ" <jj@xxxxxxxxxxxxx> wrote in message
news:2LydnRvwkJ4dZEzeRVny1g@xxxxxxxxxxxx
> 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.
>

Use adRightWriteDesign

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.