Is there anybody know how to do the record/row level locking instead of
page-locking? Could you pls provide some sample code of how to do it?

My case is when I am doing update table, I don't want to lock the whole
table/page, because I need other persons have the access to read the
other records in the same table.

If it's possible, could you pls tell me how to do it in VB?

Thanks a lot.

I don't know for a fact which Dbs support row-level locking...

--
Rebecca Riordan
{*filter*} River Solutions
Author of Designing Relational Database Systems
http://www.*-*-*.com/

Hi, All

Is there anybody know how to do the record/row level locking instead of
page-locking? Could you pls provide some sample code of how to do it?

My case is when I am doing update table, I don't want to lock the whole
table/page, because I need other persons have the access to read the
other records in the same table.

If it's possible, could you pls tell me how to do it in VB?

If you are talking about Access then I think you'll need to use 2000.

Paul
~~~~

MS says no, but reality is otherwise (gee, another big surprise <g>)

It was demonstrated & documented in the June 1999 issue of Windows
Developer's Journal (www.wdj.com) and involves setting a single flag on the
creation of the recordset and the one restriction is that the recordset may
contain no more than one record.

I would pass the code along here and now but:

1) It was someone else's tip

2) I seem to have misplaced that issue (I was just reading over that same
bit of code a couple of days ago and don't know where i put it.  sorry).

But go to the wdj site and look up the issue's contents, it was on page 67 I
believe.

It's a good one.  Just a few lines of DAO and well worth the price of the
back issue.

-Robert Smith
Kirkland WA
www.smithvoice.com/vbfun.htm

Sent via Deja.com http://www.deja.com/
Before you buy.

It was demonstrated & documented in the June 1999 issue of Windows
Developer's Journal (www.wdj.com) and involves setting a single flag on the
creation of the recordset and the one restriction is that the recordset may
contain no more than one record.

One row in the Recordset? I think that's why MS says "No". ;-)

Paul
~~~~