473,322 Members | 1,307 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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

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
5 4850
jimatqsi
1,271 Expert 1GB
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
Jun 23 '10 #2
titli
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 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.
Jun 23 '10 #3
titli
26
yes i have opned teh mini mdbs , they are like any other mdbs , created in the past
Jun 23 '10 #4
titli
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
1,726 Expert 1GB
The error usually means you have got a field name wrong
Jun 24 '10 #6

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

Similar topics

2
by: Davinder | last post by:
I am trying to invoke the following line of code within my ASP: Set oApp = Server.CreateObject("Word.Application") This results in the following error: ASP 0178 Server.CreateObject Access...
15
by: M P | last post by:
What does this mean? I am accessing an ASP page that queries Access Database thru fileDSN. I'm using IIS 5.0 Win2K SP4 Microsoft OLE DB Provider for ODBC Drivers error '80004005' General...
2
by: J. Marshall Latham | last post by:
I have a simple page trying to enter three pieces of information into a database using ODBC on a web site that has .NET Framework 1.0, so I have to use this Microsoft.Data.Odbc.dll which has been...
0
by: Mark C | last post by:
All, I have used Excel automation many times in the past without error until now. My machine has both Access 97 and XP installed but this code is written in 97 and I am using Excel XP. The code...
2
by: dailem | last post by:
I have a bit of code tied to a command button in Access that runs a query then transfers it to a new Excel worksheet (& new file). It works fine EVERY OTHER TIME THAT I RUN IT....what the 'heck...
10
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
1
by: Mikey G | last post by:
Hi, I created a simple VB.NET 2003 application through Visual Studio that connects to a MySQL database and loads a table into a Dataset, and then displays that table information in a DataGrid on a...
2
by: pericpero | last post by:
Hi There seem to be a number of posts already with this error message but none of them have helped me ... I am trying to execute some dynamic SQL from an ASP form to update or delete from a...
1
by: ashutoshvyas | last post by:
Hello All. Specially ADejii. I had generated a report in VB. For that purpose i am using ACCESS database. This database is connected via Microsoft Jet 4.0 OLE DB provider, and it is working well....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.