Exclusive Rights

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi all,
I have an access 2k database that is operating in multi-
users environment. Sometimes when I attempt to make
changes in forms or reports, I got the message "You don't
have exclusive rights to do so, changes would not be
saved". How can I get myself exclusive rights, so I can do
changes when needed, putting into consideration that I'm
the owner of the database and I gave the users permissions
to it through security workgroup.

Thanks,
Gary
 
Hi Gary,

The Object model of Microsoft Access 2000 has changed from Access 97
whereby you are required to have exclusive rights to the database to make
and save design changes.

See for details:
Exclusive lock is required for saving design changes to Access objects in
Access 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;200290

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Gary" <[email protected]>
| Sender: "Gary" <[email protected]>
| Subject: Exclusive Rights
| Date: Mon, 9 Aug 2004 10:43:04 -0700
| Lines: 12
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcR+OFKjwciA3Cj2QoCyzm3lmk+S5A==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12695
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.security
|
| Hi all,
| I have an access 2k database that is operating in multi-
| users environment. Sometimes when I attempt to make
| changes in forms or reports, I got the message "You don't
| have exclusive rights to do so, changes would not be
| saved". How can I get myself exclusive rights, so I can do
| changes when needed, putting into consideration that I'm
| the owner of the database and I gave the users permissions
| to it through security workgroup.
|
| Thanks,
| Gary
|
 
Back
Top