How to lock an MSSQL server recordset for read?

Hello,

I'm using VC++ 2005 and ADO to access an MSSQL 2000 server.

I need to lock a recordset so that noone can read (or write) the recordset.
How do I do this?

// Anders
--
English is not my first, or second, language
so anything strange, or insulting, is due to
the translation.
Please correct me so I may improve my English!
.

Relevant Pages

  • Re: How to lock an MSSQL server recordset for read?
    ... I need to lock a recordset so that noone can read the ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: textbox: counting & editing
    ... How to fill the A fill with the data from my previous recordset? ... I wish your English were better. ... I have a difficult time understanding ... B & C represents separate texbox fields which I tried to edit according ...
    (comp.databases.ms-access)
  • Re: Disconnected ado
    ... Or is it just something about writing and do you mean with recordset ... draw in a large quantity of real time data from various external feeds (Tib ... > data being provided to them using ADO .Net recordset classes. ... a read lock on the table and a write lock at row level for ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Slow transaction
    ... Now I get a nice trappable lock error during the 1 sec it takes to update - actually more than 1 sec if on a slow network connection. ... Check new RecSet is the same as the original RecSet ... Update the record set as required and invoke Update. ... Open new recordset for writing ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO and Locking
    ... then process and update the configuration through the recordset. ... perform row level locking. ... option other than lock the whole table. ...
    (microsoft.public.vb.general.discussion)