Back end database lock-up

Excuse my noobness. I am managing an access database that is shared
by 4 users. Management does not want to use any technologies outside
of access for this application (no SQL Server, etc). I have split the
database into front end and back end databases and put the front end
on each of the users' computers. All users can open the front end
simultaneously, but once somebody updates data in the form, the back
end locks up.

What I expect to happen:
- I assume that access should use optimistic locking (?) that would
only lock the records that are being updated, but it locks the entire
database.

what I've tried:
- i checked and double checked that the query and form are set to no-
locks
- I tried taking out all calculated values (string manipulations) in
the query
- I'm not the only one working on this, so there have been quite a few
other things looked at to no avail.

I'm stumped. Thanks for any help.
.

Relevant Pages

  • Re: Single database transaction across a multiple HTTP requests?
    ... Either this transaction is poorly designed, or you entire systems of stored ... You will need to change one or the other until you obtain a design that will ... > database engine. ... It is normal practice to issue the locks manually just before performing the ...
    (comp.lang.php)
  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... I wasn't looking at the locks when I used it. ... > One of the books is the MS Press "Sharepoint Products and Technologies" ... > What you say about the SQL server backup makes sense to me - to do it you'd ... > almost have to detach the database everytime you wanted to back up the site.. ...
    (microsoft.public.sharepoint.portalserver)
  • Access causing other programs to CRASH
    ... When I try to log off, I close down Outlook. ... >suddenly my users are experiencing slow response times ... >department thinks that it is the Access database but I ... >when it locks up it doesn't hit any debug errors. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: .Net framework and VB
    ... all DB operation puts locks on the tables so as the ... I have many years of expirance in designing distributed system based on ... One class which is used for all database read ... CustomerSingleSelect - a calss which gets data from customer based on ...
    (microsoft.public.dotnet.framework)
  • Re: Back end database lock-up
    ... Check the open mode and locking strategy of *each* front end. ... Default Record Locking: No Locks ... database into front end and back end databases and put the front end ... i checked and double checked that the query and form are set to no- ...
    (comp.databases.ms-access)