Access Xp Record Locking

[Ramzi]

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...

 

[Allen Browne]

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]

Ah: I didn't realize you were using DAO recoredsets here.

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

 

[Ramzi]

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??

 

[a a r o n _ k e m p f]

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

 

[Tony Toews [MVP]]

Any Suggestions??

Be advised that Aaron seldom has any useful responses.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[So Sorry For Poor Aaron]

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

 

[a a r o n _ k e m p f]

Be advised that tony is too fucking stupid to learn a grown-up
database.

and when things don't go his way-- he harrasses people and relies on
mafia tactics.

Eat shit canadian; stop stalking me, PSYCHO

 

[a a r o n _ k e m p f]

Tell me how my post wasn't helpful; asshole

I'm sick and tired of your spam, stalker

Your contributions to humanity-- basically come down to this:

a) if you're too fat and lazy to use a real database
b) keep on using a fat and lazy database just because it was
fashionable a decade ago