Does an UPDATE statement initiates recordlocking?  Because I was concerned of concurrency.
I'm using timestamp and I'm quite worried when I make an UPDATE. Especially on batch updates.
I'm not using stored procs YET I'm using Access as back end.

	And also whats the best way to execute UPDATE, INSERT and DELETE statement:
  a. using the command object or
  b. Dim DBConn as New ADODB.Connection
      
     DBConn.Open ConnStr
     DBConn.Execute (strSQL)
     DBConn.Close
     Set DBConn = Nothing

	I'm confused which one should I use :(

Thanks,

enzo c",)