Hi,
Not sure if this something you are looking for but here's what you can try
to see if it fits your situation:
- Create a macro "macro1" that opens a Form in design view
- Use the following command line to open your database (or use a shortcut)
msaccess.exe "C:\Program Files\Microsoft
Office\Office10\Samples\NorthwindCS.adp" /x macro1
What happens is that the Form I specified opens in design view resulting in
the ADP file opening in exclusive mode. If another user does the same they
will get the message can't save changes.
If I use the same command line to open the ADP file that has already been
opened in exclusive mode would receive the warning message.
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
--------------------
| Thread-Topic: sharing .adp non exclusive
| thread-index: AcRH5F7lHiA9zdL5SRubr1H+YbAvqA==
| X-WN-Post: microsoft.public.access.security
| From: "=?Utf-8?B?RS5IcnVza2E=?=" <
[email protected]>
| Subject: sharing .adp non exclusive
| Date: Tue, 1 Jun 2004 07:26:04 -0700
| Lines: 9
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:11115
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.security
|
| I've just finished an Access Project (adp)
Wich is stored on a location on the server.
The users have rights to add forms/query's and reports.
But when opening the adp file only the first person who did this has these
rights.
This behaviour is not quite perfect for our organisation.
We would rather have a way that the user who want's to edit something in
the adp opens it exclusive.
Is it possible to setup the .adp file so it opens non exclusive when
opening with a normal open file
and to have another way to open the file exclusive?
|
