TimeOut problems with reports for .adp projects

[Bossae]

Hi, I hope someone can help me.
We are developing reports for and .adp Access project. Thus, the source of our reports are stored procedures in SQL Server. The problem is that when this procedures takes more than about two minutes to finish, Access returns following error:

err.number = 2757
err.description = "There was a problem when accessing a property or a method of the OLE object.@Make one of the following actions: "

¿?

Thanks a lot from Spain.

 

[browneye]

Hi Bossae,
May be I am wrong here but as far as I know you get "timeout expired" error when there is some problem with your sql statement.
I think access doenot like case statements in query.You can run same SQL statement succesfully in SQL-Server. I am getting same error. In my query I have to use case statements..way I figured out to get over this problem is using virtual tables. I could do most of the report but not all of them.
Please let me know if you find something...

Thanks in advance.