[AccessD] A2K: Can't update (ADO) Recordset

Darren DICK d.dick at uws.edu.au
Tue Feb 3 21:46:42 CST 2004


Thank Stuart yes 3 was the answer

Have a great day and many many thanks

Darren

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Wednesday, February 04, 2004 2:23 PM
Subject: Re: [AccessD] A2K: Can't update (ADO) Recordset


> 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.
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list