View Single Post
  #2 (permalink)  
Old October 8th, 2003, 01:57 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

You can use adLockOptimistic, but you'll have to create and open the recordset by hand using its Open method.

The Execute method of the Connection object will always return a forward-only, read-only recordset, so you can't update it.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.