Linked Tables Lockout Other Users

  • Thread starter Thread starter Shadow
  • Start date Start date
S

Shadow

I have a dozen Access 2003 applications that use two pairs of linked tables.
The pair of linked tables in database OwnerDB.mdb permits opening multiple
copies of our Access applications by multiple Users. When one User opens any
application that utilizes the two linked tables in LotLane.mdb, no other user
can open any of the applications.

I have compared the permissions on both databases that originate the linked
tables and don't see any differences. Any suggestions on where to look to
remove this linked table 'lockout' from our Access 2003 suite of applications?
 
GBA said:
your description does not include mention of BE file.

are any of these dbs split dbs??
Click to expand...

No the databases are not split. All the Access applications and the two
linked databases reside on our server on mapped drive J:\. The databases are
relatively small and although drive J:\ can be accessed by 20 computers,
normal sharing of a single application is usually only 2 or at the most 3
computers.
 
multi user sharing of tables requires that the db be split. it doesn't
matter whether the db is large or small or whether there is just 3 or 4
simultaneous users. unsplit 'works' - but problems, such as you are having,
will be seen.
 
GBA said:
multi user sharing of tables requires that the db be split. it doesn't
matter whether the db is large or small or whether there is just 3 or 4
simultaneous users. unsplit 'works' - but problems, such as you are having,
will be seen.
Click to expand...
OK thanks for the answer. We still have the OwnerDB.mdb that provides two
linked tables to our other Access 2003 applications that allows multi users
without any lockouts, but the LotLane.mdb, which provides two additional
linked tables, locks out everybody after the first user.

Thanks again for your help.
 
OK thanks for the answer. We still have the OwnerDB.mdb that
provides two linked tables to our other Access 2003 applications
that allows multi users without any lockouts, but the LotLane.mdb,
which provides two additional linked tables, locks out everybody
after the first user.

Thanks again for your help.
Click to expand...

Check that every user of LotLane.mdb has read, write, create and
delete permissions to the directory in which the LotLane.mdb is
stored.
 
Bob Quintal said:
Check that every user of LotLane.mdb has read, write, create and
delete permissions to the directory in which the LotLane.mdb is
stored.
Click to expand...
Thanks Bob. I will check those permissions. It will take some time. I
hope it helps. It sounds reasonable because OwnerDB.mdb has been around for
a long time and the use of LotLane.mdb is more recent.

Shadow
 
Back
Top