[AccessD] error 3061 too few parameters 2003

Susan Harkins ssharkins at setel.com
Mon Dec 4 17:23:05 CST 2006


Runs fine for me in 2003. 

Susan H. 

Anyone know why this code would give me error 3061 - 'too few parameters'
when I run it in Access 2003 (it runs fine in A2K).

(I have created the references and there is a ref to DAO)


Dim db As Database
Dim strsql As String
Dim rs As DAO.Recordset
Set db = CurrentDb()
On Error GoTo Err_Handler

strsql = "SELECT * FROM QryHistory_PortfolioMVandIncome"

Debug.Print strsql
Set rs = db.OpenRecordset(strsql)        'error here





More information about the AccessD mailing list