Re: Record-Locking
- From: "Granny Spitz via AccessMonster.com" <u26473@uwe>
- Date: Fri, 15 Sep 2006 21:37:47 GMT
Sprinks wrote:
- Are the settings of the Default Record-Locking Strategy and the Open
Databases Using Record-Level Locking fields in Tools, Options, Advanced
specific to a database or to each station's Access installation?
They're specific to each database application. But here's the caveat:
whatever "open database" record level locking setting the first user uses to
open the app is the setting all other subsequent users who open the database
are going to use, regardless of their own setting. This setting is kept
until the last user exits the database.
- If each user is using his own copy of the front-end file, linked to the
same back-end, does that mean record-locking is not employed at all, since
they are not actually opening the same database?
Good for you! That means you already know the importance of split databases,
so you're going to deploy your app with a minimum of hurdles. Make sure that
you keep a persistent connection to the back end open to keep back end
operations as quick as possible.
Record locking is still employed, but the record locking setting in the front
end affects tables in the front end only.
--
Message posted via http://www.accessmonster.com
.
- Prev by Date: Re: Becoming the Owner
- Next by Date: Re: Multiple users
- Previous by thread: Re: Becoming the Owner
- Next by thread: Re: Record-Locking
- Index(es):
Relevant Pages
|
Loading
