Provider Cannot be found

Hi,

I am not sure where i am going wrong but everytime i run this code it gives me an Run time Error 3706: Provider Could not be Found. I have checked Activex Data Object 2.8 Reference.

Please Login or Register  to view this content.

Hi

Perhaps you did not declare the parameters properly in Access but merely entered them as criteria values in the SQL query. What does the SQL of your query look like?

You need to either declare the parameters properly in the Access query window, or perhaps use ? instead of the parameter names in your SQL query from Excel.

If they were declared properly in Access, the SQL would begin with a PARAMETER statement.

You should add this as the first line

Please Login or Register  to view this content.

Is it the same error message? If so, can you provide the SQL for qryMonthlyValues as well please?

The only thing that immediately comes to mind if you are using ADO rather than DAO, is that you should use % instead of * as the wildcard character. Other than that, I would need to see all the queries' definitions and- preferably- a database copy.

I believe this:

Please Login or Register  to view this content.

should be this:

Please Login or Register  to view this content.

Ans maybe start with a very simple SELECT statement to make sure the rest is working.

Hi Biplab, give this a try:

Please Login or Register  to view this content.

Biplab, did you have any luck solving your problem? If not, did you try the code I posted above? If it still gives errors or has problems, let us know so we can help you figure it out?

Yes that is correct, they should be added in the order they are defined in the query, but yes, you just increment the number.... note that you forgot the "s" in parameter(2)... should be parameters(2)

If the issue is resolved please remember to mark the thread as solved? Thanks in advance!