Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!   Become a Supporter    ::   Make a Contribution   
    Monthly (Recurring) Target: $300 :: Achieved: $95

Shared database problem

Discussion in 'Information Technology' started by Steve M, Oct 29, 2005.

  1. Steve M

    Steve M
    Expand Collapse
    Guest

    Hi I keep getting the follwing error
    'You do not have exclusive acess to the database at this time. Your design
    changes will not be saved.'
    I want multi user access to the forms. When this happens no one is in
    design mode. The settings are set to shared - no locks.

    I just cant understand it,

    any ideas??

    baz
     
  2. Loading...


  3. tina

    tina
    Expand Collapse
    Guest

    is your database split? that is, backend (tables only) on the server, and a
    copy of the frontend (all objects except tables) on each user's PC. if not,
    recommend you split it - multiple users in a monolithic database is just
    begging for database corruption.

    hth


    "Steve M" <baz100uknosp@hotmail.com> wrote in message
    news:egjahfC3FHA.3900@TK2MSFTNGP12.phx.gbl...
    > Hi I keep getting the follwing error
    > 'You do not have exclusive acess to the database at this time. Your

    design
    > changes will not be saved.'
    > I want multi user access to the forms. When this happens no one is in
    > design mode. The settings are set to shared - no locks.
    >
    > I just cant understand it,
    >
    > any ideas??
    >
    > baz
    >
    >
    >
     
  4. Roland

    Roland
    Expand Collapse
    Guest

    For multi user access to a single mdb file, MSAccess creates a seperate
    file with the extension "ldb". If you don't have sufficient file system
    privileges to create or access that ldb-file, it might be a problem.

    You might also want to check if there is an old ldb-file which cannot be
    deleted or updated by MSAccess. Try to delete it manually, but make
    sure that everybody closes the database first.

    Steve M wrote:
    > Hi I keep getting the follwing error
    > 'You do not have exclusive acess to the database at this time. Your design
    > changes will not be saved.'
    > I want multi user access to the forms. When this happens no one is in
    > design mode. The settings are set to shared - no locks.
    >
    > I just cant understand it,
    >
    > any ideas??
    >
    > baz
    >
    >
    >
     
  5. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    In Access 2000 and later, you must have exclusive Access to the MDB to save
    design changes. No other user must have that MDB open - it doesn't matter
    that the other users are not making design changes.

    The solution, as Tina suggests elsewhere in this thread, is to split the
    'front end' application MDB from the 'back end' data MDB, so that you can
    make design changes to a local copy of the application MDB and copy it to
    the users' PCs without overwriting data.

    --
    Brendan Reynolds


    "Steve M" <baz100uknosp@hotmail.com> wrote in message
    news:egjahfC3FHA.3900@TK2MSFTNGP12.phx.gbl...
    > Hi I keep getting the follwing error
    > 'You do not have exclusive acess to the database at this time. Your
    > design changes will not be saved.'
    > I want multi user access to the forms. When this happens no one is in
    > design mode. The settings are set to shared - no locks.
    >
    > I just cant understand it,
    >
    > any ideas??
    >
    > baz
    >
    >
    >
     
  6. ??

    ??
    Expand Collapse
    Guest

    "Roland" <roland@none> ??????:e%23R15HT3FHA.3876@TK2MSFTNGP09.phx.gbl...
    >
    > For multi user access to a single mdb file, MSAccess creates a seperate
    > file with the extension "ldb". If you don't have sufficient file system
    > privileges to create or access that ldb-file, it might be a problem.
    >
    > You might also want to check if there is an old ldb-file which cannot be
    > deleted or updated by MSAccess. Try to delete it manually, but make
    > sure that everybody closes the database first.
    >
    > Steve M wrote:
    >> Hi I keep getting the follwing error
    >> 'You do not have exclusive acess to the database at this time. Your
    >> design
    >> changes will not be saved.'
    >> I want multi user access to the forms. When this happens no one is in
    >> design mode. The settings are set to shared - no locks.
    >>
    >> I just cant understand it,
    >>
    >> any ideas??
    >>
    >> baz
    >>
    >>
    >>
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page