error 3001 when opening recordset
Posted on 2004-09-07
Hi, i'm getting an error 3001 - Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
in the line indicated below. Can anyone help please - I'm really fed up with this! The database in question is Access.
'connect to database
Set objADOConn = CreateObject("ADODB.Connection")
Set rstLight_Audits = CreateObject("ADODB.Recordset")
rstLight_Audits.Open "Light_Audits", objADOConn, adOpenDynamic, adLockOptimistic, adCmdTable 'Error here.