ADODB.Recordset (0x800A0BB9) error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   i get a "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." error when i run either of the two following bits of code:

sql = "SELECT Custname FROM Customer" 
vrec.Open sql, adoCon 

sql = "SELECT Consult, Locked FROM Consultant" 
vrec.Open sql, adoCon 

but i only get this error after running the following code:

sql = "UPDATE Consultant SET Counter = 0 WHERE Consult='" & consult & "'" 
adoCon.Execute sql, adoCon 

any ideas?

Edited by ub3rl337ch3ch - 01 May 2005 at 11:10pm