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