Locked Access Database - ldb files problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • antonio.cuartas@gmail.com
    #1

    Locked Access Database - ldb files problem


    Hi all,

    I have an Access 2000 database file on a shared network (windows)
    drive which should be accessed by several users at the same time. The
    problem is that although the database is being opened as shared mode
    (not exclusive), just *ONE* user can open it at a time. When the first
    users opens the database, a ldb file is created at the same place as
    the database file is, and another users are not able to open the
    database as long the first user has the application opened. When the
    first user closes the Access application and the ldb file is deleted,
    other user is able to open the application. Again, just one user at a
    time.

    Any ideas on how to solve this problem???

    Thanks in advance!!!
    Tags: None
    • Chris O'C via AccessMonster.com
      #2
      Re: Locked Access Database - ldb files problem

      Don't let them share the same db file. Split the db into front end (forms,
      queries, modules, macros) and back end (tables and relationships). Put the
      back end on the network share and a copy of the front end on each user's
      desktop. Make sure all users of the db have read, write and modify
      permissions on the folder where the back end is. (And delete permissions if
      you're a risk taker.)

      Chris
      Microsoft MVP


      antonio.cuartas @gmail.com wrote:
      >Hi all,
      >
      >I have an Access 2000 database file on a shared network (windows)
      >drive which should be accessed by several users at the same time. The
      >problem is that although the database is being opened as shared mode
      >(not exclusive), just *ONE* user can open it at a time. When the first
      >users opens the database, a ldb file is created at the same place as
      >the database file is, and another users are not able to open the
      >database as long the first user has the application opened. When the
      >first user closes the Access application and the ldb file is deleted,
      >other user is able to open the application. Again, just one user at a
      >time.
      >
      >Any ideas on how to solve this problem???
      >
      >Thanks in advance!!!
      --
      Message posted via http://www.accessmonster.com

        Comment

        Previous template Next
        Working...