Re: Shared v. Exclusive Access

Thank you Joan.

This is what the beast looks like:

- The front is an A2K3 MDE.
- The backend is a SQL server. Tables are linked via ODBC.
- The folder wherein the frontend resides grants Full permissions to the
Everyone group
- The LDB file, when created by the 1st user, is indeed inheriting the
permissions set at the folder level. I've checked the security properties
while a user was in the database.
- ALL subsequent users have to satisfy 31 message prompts that they do not
have exclusive access. That's right ... 31 times, every time it is opened
.... aggravating, at the least!
- When I open the database, however, I don't get the message boxes. I have
admin privileges. When I log in with CITRIX, however, with the same network
logon, I get the 31 message boxes when opening.
- The 31 message boxes appear whether during the Startup routine or even if
I hold the Shift key to bypass the startup routine. In the latter case, the
database window is visible while I have to satisfy the 31 message boxes.

Whew! Is that a mouthful! Not sure there is anything more to divulge.
Perhaps this is enough for you (or anyone else) to troubleshoot.

I appreciate your attention. Feel free to ask more questions in your effort
to understand my dilemma. Any recommendations are welcomed and fully
appreciated as well

With respect,

Bob


"Joan Wild" wrote:

"Bob Bonta" <BobBonta@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6FA24B48-31D3-4ED1-B9D6-42056DBD57DB@xxxxxxxxxxxxxxxx
Have I misunderstood the difference all along?

Can/would anyone out there take just a moment and explain, from
Microsoft's
point of view, exactly what shared access means and what exclusive access
means?

Is MS Access capable of allowing multiple users in the same database?

Yes

If
so, what type of access are the subsequent users granted upon entry - User
#1
obviously would not be restricted upon initial entry.

Depends. As long as all users have the proper Windows permission on the
folder (modify in this case), then subsequent users will be able to open the
database and only then would they be restricted based on their Access
permissions. There may be conflicts if two users are updating the same
record at the same time, but Access throws up messages to the users in this
case.

If users don't have the modify permission on the folder, then the first
person in will not be able to create the ldb file, and will open the
database exclusively.

Any insight would be most helpful as I have been battling with this
security/permissions issue for nearly 2 months and my users are about to
hang
me!

Provide some details on the battle; we'll provide some reinforcements and
help you slay the beast.


--
Joan Wild
Microsoft Access MVP



.

Relevant Pages

  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • Re: Shared v. Exclusive Access
    ... Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe ... The folder wherein the frontend resides grants Full permissions to the ... When I open the database, however, I don't get the message boxes. ...
    (microsoft.public.access.security)
  • Re: Display of Message "You do not have eclusive access toa databa
    ... > in the foder that has the database. ... >> permissions on the folder, then have one of them open the folder in ... >> permissions on the folder. ... >> Ian Shaw wrote: ...
    (microsoft.public.access.security)
  • Re: Database issue
    ... Permissions on the folder ... If you have an ISP that has a server type database, ... Second, even if you persist each hit to the database, I am not sure why ...
    (microsoft.public.dotnet.framework.aspnet)
Loading