By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,188 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

Run time error 1004 [Microsoft][Microsoft ODBC Access Error] Too few parameters

P: 26
Hi guys,
I have a .mdb which generates , further some mini .mdbs..Later these generated mini mdbs are provided as input to excel viewer.Till yesterday everything was working fine..
But today after teh mini mdbs are generated and after that i m trying to view the pivot in excel , i keep getting this error
Run time error 1004 [Microsoft][Microsoft ODBC Access Error] Too few parameters expected 1.

I need urgent help !!! please help me

The mini mdbs created earlier , through this mdbs are opening perfectly in the excel.Today whatever mini mdbs i created didnt open in the excel viewer.
Jun 23 '10 #1
Share this Question
Share on Google+
5 Replies

Expert 100+
P: 1,221
You're going to have to do some research and provide more information. This is a very generalized error report.

Have you opened the mini-mdbs yourself in Access, to look and see what is in there? Is the correct content there? It looks like Excel is following the ODBC to find the Access file, and when it opens something within that file (table? query?) the error occurs. I imagine you could skip Excel and get right to the heart of the matter in Access.

Jun 23 '10 #2

P: 26
Jim, this is very serious issue, teh users won't be able to run the file tomorrow again.i need to solve this right now.
Yes, execl is able to open the other mini databses created yetserday or befor's only today that teh generted mini dbs from the .mdb , are not opening in excel.

I have not changed any queries / table , in teh mdb which generated mini databases to be viewedin excel.
Jun 23 '10 #3

P: 26
yes i have opned teh mini mdbs , they are like any other mdbs , created in the past
Jun 23 '10 #4

P: 26
Can i call you up for some more help, if you dont mind?
If you are ok with sharing your number here, i can call you right now.
Jun 23 '10 #5

code green
Expert 100+
P: 1,726
The error usually means you have got a field name wrong
Jun 24 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.