ODBC problem

[Soegstad]

Just wondered if anybody knows how to exceed the limit for the query prosessing time.
I'm trying to import data from the AS400 system to access with an ODBC call.
However I'm getting this error msg:
....Estimated query processing time 179 exceeds limit 60. (#-666)

 

[Pat Hartman]

Open the query in design view and look at the properties. One of them sets the ODBC timeout property.

 

[Soegstad]

Thanks Pat....Always easy when you know what to do

 

[AnnPhil]

Can you tell me how to do this in MS project frontend and SQL backend?

 

[Pat Hartman]

With an .mdb front end and SQL backend, the setting is in the same place. I don't know where you would find the setting in a project. I would guess that you should examine the properties of the connection object.

 

[AnnPhil]

I can see it in Access front end not in SQL server backend, i am using the Enterprise Manager to view my queries, how are you able to see this in SQL backend?

thanks for your help

 

[Pat Hartman]

You should probably post the question in an SQL server forum.

 

[AnnPhil]

OK Pat, i thought i had posted it in the SQL forum