Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking Records

Status
Not open for further replies.
Bloobird

Bloobird

Programmer
Oct 23, 2001
49
GB
Hi - I have a form with a MSHFlexGrid, which holds a sequence of dates and other details - double clicking on a date brings up a new form, with details which can be amended for that date. The grid is not actually linked to a data source, just filled in initially from a ADODB.recordset. I want to lock the details for a particular date, so that 2 users cannot edit the date details at the same time. The second form that appears only holds text boxes, and on choosing save the values are strung into a SQL statement which is executed. What is the best way to go about this ?

Thanks
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
232
strongm
strongm
sal21
  • Locked
  • Question
fill array from recordset
Replies
6
Views
266
2009luca
2009luca
Franka71
  • Locked
  • Question
Connecting to a Disconnected Recordset...
Replies
1
Views
105
Andrzejek
Andrzejek
kskinne
  • Locked
  • Question
help with code used to update multiple records from datagrid 1
2
Replies
33
Views
451
Andrzejek
Andrzejek
vladk
  • Locked
  • Question
How to convert SqlDataReader to a Recordset in VB.NET
Replies
2
Views
131
vladk
vladk

Part and Inventory Search

Sponsor

Back
Top