Re: Back end database lock-up
- From: Salad <oil@xxxxxxxxxxx>
- Date: Thu, 13 Nov 2008 15:37:57 -0800
zmickle@xxxxxxxxx wrote:
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.
What version of Access are you using?
Is the backend on a network server?
Keith Wilby mentioned rights. I think in Novell for rights; read, write, erase (delete), modify, create. You said you had read/write. Are there other rights you can grant?
Are you up to date on program service packs on all computers?
.
- References:
- Back end database lock-up
- From: zmickle@xxxxxxxxx
- Back end database lock-up
- Prev by Date: Re: Help With Queries In Access
- Next by Date: Re: Back end database lock-up
- Previous by thread: Re: Back end database lock-up
- Next by thread: OLE a command line???
- Index(es):
Relevant Pages
|
