Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    I have front end code.mdb database on client computer and back end data.mdb database on server computer

    What a re the pros and cons of opening client front end database in Exclusive mode?

    Thanks, John

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    I don't believe there are any significant advantages or disadvantages of opening the front-end in Exclusive mode. A user will still be able to make design change as long as they have the appropriate security permissions, and Access will switch to Exclusive mode when they start to design a new object.
    Wendell

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    Hi Wendell

    There is no design done on client's computer.

    Still getting the nasty Microsoft Jet database engine stopped Error 3191 every once and a while, in my case it does not seem to be related to a corrupted record

    I can end task back to windows desktop reopen the database and the error record is OK

    I understand the error code is seriously misleading!

    I

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    Is this a new problem? I didn't find any post that seemed to be related to this problem, so some questions.
    <UL><LI>Is your back-end jet or SQL Server (or something else)?
    <LI>Have you checked to see if you have consistent versions of the MDAC dlls?
    <LI>SR-2 has not been applied - is there a reason?
    <LI>What OS is the workstation running where the problem occurs?
    <LI>Have you tried other workstations to see if they have the same problem?[/list]Hope this triggers a few ideas to try.
    Wendell

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    Hi Wendell

    Is your back-end jet or SQL Server (or something else)?
    Jet 4.0 sp6

    Have you checked to see if you have consistent versions of the MDAC dlls?
    What ara MDAC dlls? What the exact file names? and what versions should I have?

    SR-2 has not been applied - is there a reason?
    A little gun shy, should I upgrade, anything problems I should know about?

    What OS is the workstation running where the problem occurs?
    WIN 98

    Have you tried other workstations to see if they have the same problem?
    On several customers client computer and also on my development computer, happens INTERMITTENTLY, can't force it to happen, dosen

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    OK - I suspect that none of the things I suggested is contributing to your problem, but just for <img src=/S/grin.gif border=0 alt=grin width=15 height=15>s, the MSKB tells you how to check for MDAC versions issues in article 301202. But unless you are using ODBC or ADO, it seems unlikely that the MDAC is giving you trouble.

    In researching the 3191 error number, I got a completely different description - it refers to trying to create two or more fields with the same name in a table. Did we get a wrong error number here, or is there more to the description that the Jet engine being stopped? If it's the latter, odds are you are creating the problem by trying to add fields to a table in code (see <post#=168543>post 168543</post#>), or you are encountering an error of the type in MSKB article 208446.
    Wendell

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    Hi Wendell

    Sorry for the typo, error was

    (Error 3197)
    The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

    Same symptoms as Chuck's in Post 94842, however don't think it

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)

    I've seen this in Access 97 as well, and it usually meant that a record was in edit mode in the user interface and then code tried to update fields and save the same record either behind that subform or from another subform based on the same query. I've cured it in some cases by checking for the dirty condition in code and doing a saverecord *before* I tried to make any other changes.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •