Re: Cannot create new forms, reports, or macros

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 10/29/04


Date: Fri, 29 Oct 2004 00:22:32 -0600

On Thu, 28 Oct 2004 11:13:01 -0700, "Greg"
<Greg@discussions.microsoft.com> wrote:

> It appears that when one of the users with modify
>rights is in the database, regardless of whether they have any object open
>such as a table or query, or etc., Access promotes that user to having
>exclusive rights instead of just shared access and therefore, no one else can
>create a form, report, or macro.

That's correct, annoyingly enough. With A2000, there is just one "box"
for all code in the database, including all report and form code; if
anyone has the box open, Access won't let anyone else open it. This of
course makes shared development of a database all but impossible.

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps



Relevant Pages

  • Re: Terms of Use
    ... nothing about "lists" as being copyrighted. ... to even qualify as a database. ... These rights can be licensed, ... Copyright law is typically designed to protect the fixed expression ...
    (comp.lang.perl.misc)
  • 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)
  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: SUUNTO Vyper PC i/f
    ... username and password. ... to enter the database password. ... I gained access to the data in Suunto v2 using it - but it will NOT allow ... have the rights to the program the DATA is MINE!! ...
    (uk.rec.scuba)