Shared MDE gives Exclusive Access Warning

[raceri]

We have shared MDE, when second user opens gets message: You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.
The message seems to repeat for each compiled object (Form, Report and Module).
Helptext states occurs when in design mode - but not in design mode!
Any ideas as to how we can suppress the warning?

 

[jkl0]

Ideally, you should split your DB into Front-end and Back-end.

But to answer your question, under options, the default open mode needs to be shared.

 

[raceri]

Ideally, you should split your DB into Front-end and Back-end.

But to answer your question, under options, the default open mode needs to be shared.

Thanks - The DB is split (SQL back end) and default open mode is shared but we still get the problem.

 

[The_Doc_Man]

Verify that the users have the proper permissions to the folder in which the DB is stored.

Search this forum for "Windows Permissions" to see posts on this topic that might list specific situations, one of which might even be applicable.

 

[raceri]

Verify that the users have the proper permissions to the folder in which the DB is stored.

Search this forum for "Windows Permissions" to see posts on this topic that might list specific situations, one of which might even be applicable.

Thanks - that's interesting. Unfortunately need to engage another IT group to review settings but will report back when done (probably Wednesday)

 

[raceri]

Changed permissions so that all users have Full Control of files. Did not resolve problem. Forgot to mention that mde resident on Citrix server. Have decided to take different approach and only allow exclusive access. Problem was that users were not being informed of id of person already in system if they couldn't get exclusive access (not using workgroups but Active directory to control access) Application now creates text file containing details of last user accessing the system. If another user can't get exclusive access then at least they can view details of last user held in the text file outside of the application. Not very elegant but gets around problem. Thanks for all suggestions.

 

[The_Doc_Man]

CITRIX is known to give this kind of problem because there are TWO sets of permissions involved and also a mapping issue. Search the forum for CITRIX, Terminal Services, and Remote Mapping. I don't recall that the problem has always been solved but again, relevant threads exist.