×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Too few parameters. Expected 5. AHHH!! HELP PLEASE

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

RE: Too few parameters. Expected 5. AHHH!! HELP PLEASE

Tony,

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

(OP)
Thanks for your ideas.  I found some problems associated with the code I wrote on the pocket pc database.  This is my first time working the pocket pc's and I'm the only guy working on this project in my department, so I've come across many snag's.  I really appreciate your response/help.
Tony

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close