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

[titli]

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.

[jimatqsi]

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.

Jim

[titli]

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 ethat..it'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.

[titli]

yes i have opned teh mini mdbs , they are like any other mdbs , created in the past

[titli]

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.

[code green]

The error usually means you have got a field name wrong