Re: How to control the locks in Access with ADOExpress ?

Article View: borland.public.cppbuilder.database.ado

Article #5189

Back to borland.public.cppbuilder.database.ado Previous Next

#5189

From: Alon Novy
Date: Fri, 29 Jun 2001 09:11

24 lines
1666 bytes

Carlos

Access will support optimistic locking.  You can set the locking for the
TADOCustomDataSets and descendents using the LockType property.

BTW Access locks along a a 1k page (I think it's 1k).  That means that when
a user is modifying a record adjacent records (ie. records that are not
actually in use) will also be locked.

Alon

"Carlos" <shangri-la@teleline.es> wrote in message news:3b31a80b_1@dnews...
> Hi, How can i control the locks in a record when several users want to
> modify it.
>
> Now i control it from my program, but i want to know if exist some way to
do
> it in the Access configuration, without using code to control.
>
> Thanks.
>
>
>
>

Technical Details

Message-ID: <3b3c439d_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3b31a80b_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2a799299afb21387
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-29 02:09:44 PST
Reply-To: "Alon Novy" <alon.novy@thinksoftware.com.au>
From: "Alon Novy" <alon.novy@thinksoftware.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b31a80b_1@dnews>
Subject: Re: How to control the locks in Access with ADOExpress ?
Date: Fri, 29 Jun 2001 19:11:25 +1000
Lines: 26
Organization: Think Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 203.32.175.13
Message-ID: <3b3c439d_1@dnews>
X-Trace: dnews 993805213 203.32.175.13 (29 Jun 2001 02:00:13 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message