Cannot create new forms, reports, or macros

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Stone (anonymous_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 10:54:50 -0700

hi,
Access has a security section where passwords,permissions,
rights, users, user groups, ect can be created and
administered.
If things seem odd to you, you need to talk to whoever set
that up.
Tools>security>Pick from list
Regards
Frank

>-----Original Message-----
>I have a shared database on our LAN and have user rights
setup to allow only
>two persons to modify existing objects in the database.
However, anyone can
>create new objects. The problem is however, that people
can only create new
>tables and queries but not forms, reports, or macros.
Why is this?
>
>I also keep receiving the message about not
haveing "Exclusive rights" to
>the database when the other user with the right to modify
is in the database.
>Why is this?
>
>Thanks,
>Greg
>.
>

Relevant Pages

  • Re: Backend Ldb file
    ... the network rights are EXACTLY the problem. ... work as intended, all users should have Create, Modify, and Delete rights as ... If a user cannot create the LDB, ... > in the database on the previous day, but is not at work on ...
    (microsoft.public.access.setupconfig)
  • Re: insert a record
    ... If you create a folder called c:\db and set security rights with Windows ... Explorer to 'change' or 'modify' for the IUSR_computername account, ... you have to move the database into that folder. ... without even the implied warranty of merchantability ...
    (microsoft.public.inetserver.asp.db)
  • Re: What user rights on the server files
    ... You also need Write for Admin users (they need to modify users.txt when ... adding new users in database, etc, or to modify srcsafe.ini when changing ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: Error code = 4060
    ... divisional portals are running under a different app pool and identity than ... the corporate portal, and the identity of this pool, while having dbo rights ... portal's content database. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)