Welcome to SPN

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

Sign Up Now!

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
    >>
    >>
    >>
     

Share This Page