Prev: Error exporting data from access 2007 to excel 2007
Next: Disable Search and Replace
From: Ramzi on 5 Jul 2008 03:54
Hello every body;



I am using Access Xp, I wonder if there is a setting that will make the
locking for one record instead of a multiple records (page) when opening a
recordset containing only one record for editing? it will lock the near by
records...


From: Allen Browne on 5 Jul 2008 04:53
There is a setting under Tools | Options.
From memory, it's on the Advanced tab.

Record-level locking works for most situations, though it will probably be
slower. There are cases where it doesn't work propertly, e.g. executing
action queries in a transaction may fail.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ramzi" <ShamiSoft(a)hotmail.com> wrote in message
news:uk8MAwm3IHA.4988(a)TK2MSFTNGP04.phx.gbl...
> Hello every body;
>
> I am using Access Xp, I wonder if there is a setting that will make the
> locking for one record instead of a multiple records (page) when opening
> a recordset containing only one record for editing? it will lock the near
> by records..

From: Ramzi on 5 Jul 2008 09:16
Thank you for your fast respond...

In fact although the <Record-level locking > is marked it still locking a
group of record when using the OpenRecordSet command and edit the recordset
while another user is editing the previous/next record??

Any Suggestions??




"Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in message
news:Ovk7eyn3IHA.2064(a)TK2MSFTNGP02.phx.gbl...
> There is a setting under Tools | Options.
> From memory, it's on the Advanced tab.
>
> Record-level locking works for most situations, though it will probably be
> slower. There are cases where it doesn't work propertly, e.g. executing
> action queries in a transaction may fail.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Ramzi" <ShamiSoft(a)hotmail.com> wrote in message
> news:uk8MAwm3IHA.4988(a)TK2MSFTNGP04.phx.gbl...
>> Hello every body;
>>
>> I am using Access Xp, I wonder if there is a setting that will make the
>> locking for one record instead of a multiple records (page) when opening
>> a recordset containing only one record for editing? it will lock the near
>> by records..
>


From: Allen Browne on 5 Jul 2008 08:35
Ah: I didn't realize you were using DAO recoredsets here.

That won't work:
http://support.microsoft.com/kb/306435

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ramzi" <ShamiSoft(a)hotmail.com> wrote in message
news:es4AGkp3IHA.3384(a)TK2MSFTNGP04.phx.gbl...
> Thank you for your fast respond...
>
> In fact although the <Record-level locking > is marked it still locking a
> group of record when using the OpenRecordSet command and edit the
> recordset while another user is editing the previous/next record??

From: a a r o n _ k e m p f on 5 Jul 2008 20:01
yes, JET locking sucks.
Move to SQL Server; and you'll have much much much better control over
your locking

for example:
Select * from Employees With (NoLock) Where Employees.ID = 12

SQL Server is the most popular engine in Access 2002-2003.. I'd
definitely reccomend upsizing to ADP.

-Aaron




On Jul 5, 6:16 am, "Ramzi" <ShamiS...(a)hotmail.com> wrote:
> Thank you for your fast respond...
>
> In fact although the  <Record-level locking > is marked it still locking a
> group of record when using the OpenRecordSet command and edit the recordset
> while another user is editing the previous/next  record??
>
> Any Suggestions??
>
> "Allen Browne" <AllenBro...(a)SeeSig.Invalid> wrote in message
>
> news:Ovk7eyn3IHA.2064(a)TK2MSFTNGP02.phx.gbl...
>
> > There is a setting under Tools | Options.
> > From memory, it's on the Advanced tab.
>
> > Record-level locking works for most situations, though it will probably be
> > slower. There are cases where it doesn't work propertly, e.g. executing
> > action queries in a transaction may fail.
>
> > --
> > Allen Browne - Microsoft MVP.  Perth, Western Australia
> > Tips for Access users -http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
>
> > "Ramzi" <ShamiS...(a)hotmail.com> wrote in message
> >news:uk8MAwm3IHA.4988(a)TK2MSFTNGP04.phx.gbl...
> >> Hello every body;
>
> >> I am using Access Xp, I wonder if there is a setting that will make the
> >> locking for one record instead of a multiple records (page) when opening
> >> a recordset containing only one record for editing? it will lock the near
> >> by records..

 |  Next  |  Last
Pages: 1 2
Prev: Error exporting data from access 2007 to excel 2007
Next: Disable Search and Replace