Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem with Sharing Access database (2000)

    I am trying to share an Access database, so 2 users can access the database at the same time.
    I am getting attached error message, is there any way to resolve this issue?
    Attached Images Attached Images

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Location
    Hastings, Sussex, England
    Posts
    67
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Problem with Sharing Access database (2000)

    JJ,

    First question is, have you split the front end from the data tables? This is recommended practice for several reasons. That way, each user can have their own copy of the front end.

    If you have not gone down this route, then most probably one person has opened the database 'exclusively'. The default mode is normally 'shared', but this can be changed. Or, they are in the process of making changes to database objects and this has locked the system.

    Regards,

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Sharing Access database (2000)

    I now appear to get the attached error? , how can l by pass this error?
    Can you tell me how l split the front end from the data tables?
    Attached Images Attached Images

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    Hastings, Sussex, England
    Posts
    67
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Problem with Sharing Access database (2000)

    (Edited by HansV to make URLs clickable - see <!help=19>Help 19<!/help>)

    You'll see this, or a similar error, until all but one person has closed the database.
    To split the front and back ends, the simple way is to take a copy of your file so there are two identical databases. Delete everything but the tables from one copy. Put this on a shared network drive. From the other copy, delete the tables. Then create a link to the back end tables on the network drive. Give a separate copy of the front end to each user. Do not move the back end, or the links will break.

    There's an old article about this at http://support.microsoft.com/kb/142467. A more up to date article is at http://support.microsoft.com/kb/304932.

Posting Permissions

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