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

.

Relevant Pages

  • RE: Check for Exclusive
    ... revise and implement it into our live database. ... "Paolo" wrote: ... Look at the size of the ldb file. ... If a user opens the database when it was not previously open, ...
    (microsoft.public.access.modulesdaovba)
  • Re: .ldb files
    ... Unless the users have full rights to the folder that the database ... meaning that if a .ldb file exists (Someone has ... so opens the file as read only). ...
    (microsoft.public.access.security)
  • Re: .ldb files
    ... >> that Microsoft could and should rectify! ... >> created a database which merges data from two folders. ... so opens the file as read only). ... >> Surely if when Access fails to create a .ldb file it ...
    (microsoft.public.access.security)
  • Re: close / rename linked .mdb file
    ... except when Access "opens" it to deal with the ... code in the startup procedure which opens a database or recordset ... Opening the .ldb file using notepad will show you both who's currently ... Determining the workstation which caused the Microsoft Access MDB ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access Database - Locked out from Design
    ... What happens if the 'owner' of the ldb file tries to delete it? ... permissions issue - maybe your permissions are set up such that only the ... 1- User "A" opens the database, and Access creates the .ldb file in the ...
    (microsoft.public.access.tablesdbdesign)