Re: MS SQL 2000, ADO and edit lock

Select a single row with "lock".
If another user tries to select the same row with "lock", he wont be able
to. You can check the exception codes to make sure but the assumption is
that it is not selectable because it is locked.



.

Relevant Pages

  • Re: Ensuring a nice clean application quit experience
    ... My preferred design is to have a table with a single row that contains ... the network name of the person currently connected to the database. ... there is no 100% reliable way to delete the record on exit. ... The record lock should release when Access shuts down. ...
    (comp.databases.ms-access)
  • Re: Session_OnEnd event doesnt fire
    ... >> But because of the page lock, isn't there a risk for a user to lock ... > primary key that will assure that consecutive session id's will not be ... > contains a single row of data. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)