[AccessD] error 3061 too few parameters 2003

Kath Pelletti kp at sdsonline.net
Mon Dec 4 17:06:13 CST 2006


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


______________________________________
Kath Pelletti
Software Design and Solutions Pty Ltd.
Ph: 9505-6714
Fax: 9505-6430
Email: KP at SDSOnline.net


More information about the AccessD mailing list