Hi Chris,
If we can prevent multiple instance of the ade from running, the second or
late users are unable to open it, since the first user always open it in
exclusive mode; when the user creates two secession or connects on two
workstation, they are running two instances of their own copy; the
resolution is to keep ade running in one instance. You may want to refer to
the code in article:
Preventing multiple instances of a database
http://www.mvps.org/access/api/api0041.htm
Please feel free to reply to the threads if you have any concerns or
questions.
Note: This response contains a reference to a third-party World Wide Web
site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Chris Cairns" <
[email protected]>
Tomcat-NG: microsoft.public.access.formscoding
|
| Actually each user already has their own copy of the .ade file. The
| problem only occurrs when that user creates multiple sessions on the
| terminal server or opens it on two workstation. (Their copy is located in
| their home directory.)
|
| What I need to know is how to detect if another copy is already open for
| that particular user either in another terminal session or on another
| workstation and then be able to halt my application with a message stating
| that another copy is already open.
|
| I was hoping their might be a way to capture that error message about the
| read-only
| or some way to tell access to close the application if it is unable to
open
| the .ade in exclusive mode.
|
|
|
|
|
|
| | > Hi Chris,
| >
| > Is the adp file shared on some Server? The first user opens the shared
adp
| > fine, however, when the second or late opens the shared adp, he receives
| > the read-only message? If so, this is by design; for more, please refer
to
| > the articles:
| >
| > About using a Microsoft Access project in a multiuser environment
| >
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
| > l/acconAboutUsingADPInMultiuserEnvironment.asp
| >
| > Q296263 ACC2000: Access Data Project Cannot Be Shared as Expected
| >
http://support.microsoft.com/support/kb/articles/q296/2/63.asp
| >
| > If each user has their own copy of the Access project file that is
| > connected to the same MSDE/SQL, testing shows it won't have the
read-only
| > message.
| >
| > Please feel free to reply to the thread if you have any concerns or
| > questions.
| >
| >
| >
| > Sincerely,
| >
| > Alick Ye, MCSD
| > Product Support Services
| > Microsoft Corporation
| > Get Secure! - <
www.microsoft.com/security>
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| > --------------------
| > | From: "Chris Cairns" <
[email protected]>
| > | Subject: Can you force exclusive mode?
| > |
| > | I have an access .ade project. Because if it's connectivity each
user
| > has
| > | their own copy of hte .ade file, however in some situations a user may
| > grab
| > | another session or try to open on another computer. The first copy is
| > just
| > | fine, but the second copy shows the open in read-only but allows them
to
| > | answer ok. Is it possible to detect this mode and force the program
to
| > | close whenever it's encountered.
| > |
| > | I already have the .adp set to look for multiple instances and that is
| > | working great, but it's just when its opened on more than one
computer.
| > |
| > |
| > |
| > |
| >
|
|
|
