Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access 2000 - You do not have exclusive access to the database at this time

Discussion in 'Information Technology' started by michael.meyer@brennanit.com.au, Nov 9, 2005.

  1. michael.meyer@brennanit.com.au

    Guest

    Hi All

    I am hoping someone may be able to help.

    On a Citrix Server running Access 2000 (OS = W2K3) we get the following
    error whenever we open ANY database more than once. You do not have
    exclusive access to the database at this time. If you proceed to make
    changes, you may not be able to save them later.

    I have been researching this error and have only found references to if
    the system.mdw and the database file reside in the same location. which
    for this exercise they are not in the same directory.

    I have also found information about spliting the database, which some
    databases are split and other very simple that they are not.

    and the other I have found references this problem occuring when
    database design changes are being which none are occuring.

    I initally thought the system.mdw file was corrupt so I copied it from
    another server which is working OK and then re-joined it, but to no
    success.

    So far this happens evey time a database is opened more than once at
    the same time and only in Access 2000. I am going bannanas and so far
    my searches in the groups do not suggest a resolution to this one.

    Does anyone have sugestions?

    Thanks
    Mike
     
  2. Loading...


  3. Nick Coe \(UK\)

    Nick Coe \(UK\)
    Expand Collapse
    Guest

    Double check that you're opening the database in shared mode
    under Tools|Options IIRC.

    Could be a locking file (.ldb) left after a crash,
    corruption or improper closedown. Close Access, make
    CERTAIN no one else is trying to open that mdb and then look
    for the .ldb file in the same directory as the .mdb. If
    it's NOT there you're OK and if it is there delete it, copy
    your mdb for backup purposes and run compact/repair.

    --
    Nick Coe (UK)
    Available - Will work for money :)
    http://www.alphacos.co.uk/ AccHelp + pAnimal
    http://www.pjandcoe.co.uk/ Online Store

    In
    news:1131511426.573106.259660@g47g2000cwa.googlegroups.com,
    michael.meyer@brennanit.com.au typed:
    > Hi All
    >
    > I am hoping someone may be able to help.
    >
    > On a Citrix Server running Access 2000 (OS = W2K3) we get
    > the
    > following error whenever we open ANY database more than
    > once.
    > You do not have exclusive access to the database at this
    > time.
    > If you proceed to make changes, you may not be able to
    > save
    > them later.
    >
    > I have been researching this error and have only found
    > references to if the system.mdw and the database file
    > reside
    > in the same location. which for this exercise they are not
    > in
    > the same directory.
    >
    > I have also found information about spliting the database,
    > which some databases are split and other very simple that
    > they
    > are not.
    >
    > and the other I have found references this problem
    > occuring
    > when database design changes are being which none are
    > occuring.
    >
    > I initally thought the system.mdw file was corrupt so I
    > copied
    > it from another server which is working OK and then
    > re-joined
    > it, but to no success.
    >
    > So far this happens evey time a database is opened more
    > than
    > once at the same time and only in Access 2000. I am going
    > bannanas and so far my searches in the groups do not
    > suggest a
    > resolution to this one.
    >
    > Does anyone have sugestions?
    >
    > Thanks
    > Mike
     
  4. Mike

    Mike
    Expand Collapse
    Guest

    Nick Coe (UK) wrote:
    > Double check that you're opening the database in shared mode
    > under Tools|Options IIRC.
    >
    > Could be a locking file (.ldb) left after a crash,
    > corruption or improper closedown. Close Access, make
    > CERTAIN no one else is trying to open that mdb and then look
    > for the .ldb file in the same directory as the .mdb. If
    > it's NOT there you're OK and if it is there delete it, copy
    > your mdb for backup purposes and run compact/repair.
    >


    Hi Nick

    I have checked each DB and they are all set to Shared.

    I have checked each DBs lock File and they are being created and
    removed correctly.

    I have run a Copact and Repair on each DB to no result also.

    Any other ideas?

    Thanks
    Mike
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Citrix and Terminal Server have per user licenses and usually only allow a
    user to logon once. The default unsecured Access user is "admin" and if you
    don't have a split database, this can bite you.

    The solution is to have a separate folder for each user with a front-end in
    that folder. The data (back-end) can reside in a central directory either on
    the Citrix server, or on any other server that Citrix can see on the
    network. Our local Access apps run from 20 remote locations to a Terminal
    Server in Orlando connected to a server database which is also used by 30
    other local Access users. We use a separate front end for every user and
    have absolutely no problems.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    <michael.meyer@brennanit.com.au> wrote in message
    news:1131511426.573106.259660@g47g2000cwa.googlegroups.com...
    > Hi All
    >
    > I am hoping someone may be able to help.
    >
    > On a Citrix Server running Access 2000 (OS = W2K3) we get the following
    > error whenever we open ANY database more than once. You do not have
    > exclusive access to the database at this time. If you proceed to make
    > changes, you may not be able to save them later.
    >
    > I have been researching this error and have only found references to if
    > the system.mdw and the database file reside in the same location. which
    > for this exercise they are not in the same directory.
    >
    > I have also found information about spliting the database, which some
    > databases are split and other very simple that they are not.
    >
    > and the other I have found references this problem occuring when
    > database design changes are being which none are occuring.
    >
    > I initally thought the system.mdw file was corrupt so I copied it from
    > another server which is working OK and then re-joined it, but to no
    > success.
    >
    > So far this happens evey time a database is opened more than once at
    > the same time and only in Access 2000. I am going bannanas and so far
    > my searches in the groups do not suggest a resolution to this one.
    >
    > Does anyone have sugestions?
    >
    > Thanks
    > Mike
    >
     
  6. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I doubt it. I have run Access 97 through 2002 on both Win 2K and Win 2K3
    Terminal Servers. I must admit, I like the 2003 servers better as they are
    easier to manage. I suspect that your problems on the 2003 server are
    permissions oriented. Microsoft makes sure 2003 servers have many of the
    previously defaulted on settings, turned off. Unfortunately, I am not an
    expert in servers any more, having given most of that up years ago when I
    started working as a developer full time.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Mike" <michael.meyer@brennanit.com.au> wrote in message
    news:1131569145.319475.225180@g44g2000cwa.googlegroups.com...
    > Hi
    >
    > I understand what you are saying, however the initial thought of this
    > is daunting.
    >
    > The weird thing is that I have an old Citrix Server, which they all
    > work fine on, the only difference is that the old server runs W2K
    > instead of W2K3. When I need to I can load balance the app between the
    > two citrix servers and those on the old server work but those on the
    > new one do not.
    >
    > Do you think that W2K3 could be causing it, or have an variable that
    > may be effecting this?
    >
    > Mike
    >
     
  7. Mike

    Mike
    Expand Collapse
    Guest

    Ideally I would like to keep the Application as a single copy running
    from the server since this is what we have been using, and the task to
    change Citrix to use many copies for each user is a large task to
    implement.

    Do you have any ideas which permissions I should be looking at what
    what for?

    Does anyone else out there have any ideas?

    Cheers, thanks for all you help
    Mike
     
  8. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "Mike" <michael.meyer@brennanit.com.au> wrote in message
    news:1131674808.631898.327100@g44g2000cwa.googlegroups.com...
    > Ideally I would like to keep the Application as a single copy running
    > from the server since this is what we have been using, and the task to
    > change Citrix to use many copies for each user is a large task to
    > implement.


    Unfortunately, this may lead to corruption, but of course if you have good
    backups and an understanding boss, that should be of little worry.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  9. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Mike wrote:
    > Ideally I would like to keep the Application as a single copy running
    > from the server since this is what we have been using, and the task to
    > change Citrix to use many copies for each user is a large task to
    > implement. [snip]


    Actually setting up a Citrix Access app so that each user has their own copy of
    the front end is a task that would take about 5 minutes. Setting up a system to
    automatically propogate updates of that front end as they are issued would take
    a few minutes more.

    Both require some knowledge and you might have to acquire some free tools
    (depending on requirements), but there really is no excuse not to do this the
    proper way rather than the improper way. You've spent more time posting to
    these groups than it would have taken to accomplish.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     
  10. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Mike" <michael.meyer@brennanit.com.au> wrote:

    >Ideally I would like to keep the Application as a single copy running
    >from the server since this is what we have been using, and the task to
    >change Citrix to use many copies for each user is a large task to
    >implement.


    As the others have stated you do not want to share a FE as it will corrupt sooner or
    later. And/or have other interesting problems.

    As far as setting up Citrix goes all you need is a one line .cmd file which calls the
    msaccess.exe and passes the name of the FE MDB/MDE. Alternatively if you want to use
    my Auto FE Updater to keep the FE updated then create a one line .cmd file which
    calls the startmdb.exe and passes the path and name of the INI configuration file.

    I specifically created the Auto FE Updater utility so that I could make changes to
    the FE MDE as often as I wanted and be quite confident that the next time someone
    went to run the app that it would pull in the latest version. For more info on the
    errors or the Auto FE Updater utility see the free Auto FE Updater utility at
    http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up
    to date.

    In a Terminal Server or Citrix environment the Auto FE Updater now supports creating
    a directory named after the user on a server. Given a choice put the FE on the
    Citrix server to reduce network traffic and to avoid having to load objects over the
    network which can be somewhat sluggish.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  11. AusDesi

    AusDesi
    Expand Collapse
    SPNer

    Joined:
    Jul 18, 2009
    Messages:
    347
    Likes Received:
    211
    It has alot to do with what the females in particular teach you in the family. If they don't teach you to respect women and don't discipline you when you do then You're heading for the hawalat in not too long. Same goes with the males.

    I think its kind of impossible to remove rape 100% from society just as it is impossible to remove murder but if kids are given the right direction at home then its much harder for them to go down the wrong path.

    Also, I must say nowadays or even in the past not all Indian mothers have been kind to other people's daughters. When you don't respect someone else's daughter who will respect yours.
     
  12. Lee

    Lee
    Expand Collapse
    SPNer

    Joined:
    May 17, 2005
    Messages:
    495
    Likes Received:
    377
    If it is via Citrix it could be that the citrix connection does not close properly on logout, talk to your Citrix admin.
     

Share This Page