Backend Open Mode Shared or Exclusive?

[EddyLLC]

Here is a question form a relatively uniformed new user. For a backend database should the Default Open Mode be Shared or Exclusive?

Thanks

 

[Remou]

I would say Shared, because that is the whole point of a back-end is it not, to share data?

 

[EddyLLC]

Logical, no wonder it escaped me. Thanks for the response.

 

[JScannell]

Funny thing happened with a new db that my collegue just created. He set up users/groups such that developers can do everything, and regular users can only do open/run.

He logged as a regular user and got a "you can't open in exclusive mode..." error.

He asked me what it meant since he didn't open it exclusive. I suggested trying to do the Open -> select the db -> choose "Run" from the drop down. This would have opened it in shared mode -- and it worked! From now on he doesn't have a problem when logging in as a regular user.

My question is, did my forcing it to open in shared mode remove any remembrance of previously being opened exclusive?

I told him to to do Tools ==> Options ==> Advanced ==> Default Open mode = Shared and he said that was already the way it was setup.

Any ideas what happened?

Thanks,
Jerry

Jerry Scannell

 

[Remou]

Hello JScannell
It is best to start your own thread. It is fairer to EddyLLC and you will get a better range of responses.