Too few parameters. Expected 5. AHHH!! HELP PLEASE
Too few parameters. Expected 5. AHHH!! HELP PLEASE
(OP)
I keep getting this error message when I attempt to sync my pocket pc database back to access. If anyone knows how to fix this I'd greatly appreciate it. I've been pulling my hair out just to get this far, arrrgghhh!!
Thanks,
Tony
Thanks,
Tony
RE: Too few parameters. Expected 5. AHHH!! HELP PLEASE
How are you updating the data that is on your pocket pc?
What version of Access are you using??
The link below will bring up the Microsoft Knowledge base with a query for Access and "Too few parameters".
http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=gsfxAdvancedSearch_Query&Product=acc&Queryc=%22Too+few+parameters%22&Query=%22Too+few+parameters%22&KeywordType=PHRASE&maxResults=25&Titles=false&numDays=
You'll see that a number of the articles refer to parameter_queries.
Do you have any code associated with either update or insert or data rows that might possibly be associated to a parameter_query???
Just some guesses.
That's all I can come up with without seeing the database itself.
I would be happy to try it on my machine if you are comfortable in emailing the database to me and it is not too large.
Good Luck
Robert
RE: Too few parameters. Expected 5. AHHH!! HELP PLEASE
Tony