Re: Shared v. Exclusive Access

The '31 times' is the key, believe it or not. This is caused by Adobe
version 7. To fix...

Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe
PDF. Expand to Acrobat PDF Maker and expand to locate Access; deselect the
add-in for Access.

I would suggest that you put a copy of the frontend on each user's
workstation, rather than have them share the same frontend file on the
server.

--
Joan Wild
Microsoft Access MVP
"Bob Bonta" <BobBonta@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:08559FB8-657B-4BC3-B6E9-C35316044278@xxxxxxxxxxxxxxxx
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: Shared v. Exclusive Access
    ... 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: Access Connection problem in aspx page
    ... Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet ... Access databse require read/write (Modify) permissions for the _folder_ ... containing the database file. ...
    (microsoft.public.inetserver.asp.db)
  • Workgroup Setup, Permissiions and Multi-user questions
    ... permissions for the approx. ... full control, modify, read & execute, read, and write? ... Basically, I maintain the database, create tables ...
    (microsoft.public.access.security)
  • Re: how due I unsecure a database
    ... can go in and modify the database - we no longer have a need for ... get in and modify with out that. ... That should work after giving "Users" permissions ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Why cant I modify my contacts in Access even though it is linked.
    ... Following the instructions on how to link Outlook contacts to an Access ... database, I am able to view this information but not modify it in Access. ... keep getting the message "You do not have the necessary permissions to use ...
    (microsoft.public.office.misc)