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)

 

[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?

 

[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

 

[AnnPhil]

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