Stuart McLachlan
stuart at lexacorp.com.pg
Tue Feb 3 21:23:31 CST 2004
On 4 Feb 2004 at 13:44, Darren DICK wrote: > Sigh > Still don't work > Now I get runtime error 3001 > Arguments are of the wrong Type, are out of acceptable range, > or are in conflict with one another. > The the debug highlights the line... > > rs.Open sel_SQL, con, 1, 512 > > The field in the underlying table does exist. And is named correctly > I dunno > 512 is *way* out of acceptable range ADBOB locktype constants are: adLockBatchOptistic = 1 adLockOptimistic = 3 (the one you want) adLockPessimistic = 2 AdLockReadOnly = 1 -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.