RecordSet Locktype

Results 1 to 2 of 2

Thread: RecordSet Locktype

  1. #1
    Join Date
    Dec 1969

    Default RecordSet Locktype

    I have an access db which I want to let users update and amend their own information. What is the correct record set type for allowing multiple users to amend their details ?<BR>I&#039m not clear on the exact uses for each lock type property.<BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: RecordSet Locktype

    I have used the following to update a recordset by using the recordset.addnew method:<BR> set RS= server.CreateObject("ADODB.Recordset")<BR> RS.Open "Table1", "DSN=Exper", adOpenDynamic,adLockPessimistic<BR> <BR> RS.AddNew<BR> RS("fldOne")= Ucase(Request.Form("radio1"))<BR> RS("fldTwo")= Ucase(Request.Form("radioA"))<BR> RS("fldThree")= Ucase(Request.Form("radio3"))<BR> RS("fldDate_Sub")= Request.Form("when")<BR> RS.Update<BR><BR>Hope this helps!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts