Results 1 to 6 of 6

Thread: Access (2000)

  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Huntingdon, Cambridgeshire, England
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access (2000)

    A member of staff has an Access database created in 97, taken into 2000. She is now suffering with a Microsoft "feature" in that sometimes, the first person who accesses the database in the morning has exclusive rights, but other days all users can access it.

    Her IT support personnel have advised that it is a feature, but Microsoft haven't given a workaround. Does anyone know of anything that can help her?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access (2000)

    What do these users do when they access the database? Do they use design mode to modify forms/reports?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access (2000)

    Her IT department probably has only the vaguest idea of how to work with Access themselves, so I wouldn't be too quick to accept their word as final. However, if the situation is as Mark suggested, that several people might try to modify design features when others are in the database, then there is no workaround because that's the way it should always have worked and they finally got it right.

    Access 97 allowed you to make design changes to a database while others were in it. Access 2000 and later do not. Period, end of discussion. I had plenty of problems in 97 with making and saving changes and discovering the next day that someone else still had the database open after I exited, so that whatever they had open overwrote my changes when they exited. The last one who saved won.

    Access 2000 simply doesn't allow that situation to arise, and I for one, am grateful.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Jun 2002
    Location
    Huntingdon, Cambridgeshire, England
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2000)

    Thanks for your thoughts Charlotte. I have had a word with the lady in question today and found out the following. The personnel with access to the database are nearly all inputters. They delete, create and amend records, also may create new queries - will the creation of new queries (through design view) cause the issue? All the tables are locked (good) and only she goes into the design of reports and/or forms.

    I am assuming from what both you and Mark have said, that this is probably what is causing the situation.

    Thanks again for your help.

    Jackie

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

    Re: Access (2000)

    <hr>I am assuming from what both you and Mark have said, that this is probably what is causing the situation.<hr>
    Yes - that is definitely the cause of the problem. For that reason alone, most people developing Access 2000 apps have now gone to a split database, and more often then not they put the front-end on the user's workstation. In that situation you can develop on a copy where you have exclusive access, and then deploy it to the users after it has been tested. If you want further advice on splitting the database, there's lots of threads about it in this forum.
    Wendell

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access (2000)

    I had this problem with one where one user kept changing controls to bold. That is a design change! Consequently others were locked out.
    David Grugeon
    Brisbane Australia

Posting Permissions

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