MS Access 2010 - Required data provider properties could not be set

Hi Experts,

I have a MS Access 2010 Report that is using a Stored Procedure from SQL Server 2008R2

When I try the Report in View Mode I get an error:
"Required data provider properties could not be set"

any idea's what maybe causing this.  I just changed the: Access Options>Client Settings>Advanced
to OKE/DDE timeout (sec) to 99,999 so that this does not timeOut.

Thanks.
Amour22015Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Change the timeout back to what it was and if the issue no longer occurs, then 99,999 is not a valid value for the property.

By the way, a zero is usually the way to indicate an unlimited timeout for most things.

Jim.
0
 
Amour22015Author Commented:
I changed it back to what it was set at 30

But I am getting the same error.

Thanks
0
 
Amour22015Author Commented:
I changed to what you mentioned "0" and now it is back to timing out.

So at least the error is gone
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
What provider are you using or how are you calling the stored procedure?

Jim.
0
 
Amour22015Author Commented:
I am calling the SP on: "Record Source" = Stored Procedure.

On the SQL Server side that SP takes about 2 mins to run.

On the MS Access Report it is a simple report with one subreport as a Report header which only has Company Logo and address.

I am new to all this so:

What do you mean provider?  and how do I find what provider?

Thanks
0
 
Amour22015Author Commented:
I set the time out to 300 and it seems to work fine.  But on the SQL Server side taking about 2 mins seems to long.
0
 
Amour22015Author Commented:
Thanks for your help
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<What do you mean provider?  and how do I find what provider?>>

 Using an ADP then...

<<But on the SQL Server side taking about 2 mins seems to long. >>

  Two minutes does sound like a very long time for anything, but then it depends on what procedure is doing, size of the tables, indexing, etc.

Jim.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.