Hi I am having another problem, One of our client is using MS Access. He is accessing Navision tables through link tables. And had made few queries on the basis of those. But when he execute the queries after few minutes he start getting the message query timed out with the message Do you want to Abort?. Even If I have unchecked the query time out box under options of ODBC Connections. The queries works correctly but the only thing you have to keep pressing the NO button. Does anybody put some light on this [|)]
If you go into the query properties in Access and set the ODBC timeout from 60 to 0, it will not time out on you anymore.
Sorry, But it still doesn’t work… I have ticked off the query time under query properties in access and also on odbc connection. Regards,
Hi, Please check your query.This is the query problem.I was also getting the same error while accessing the Navision tables through link in Access. After changing the query it’s working fine. You can send me your query at rkjais75@rediffmail.com. I will try to solve it
Hi rajesh, It was working before the upgrade from 2.0 to 2.60. Just after getting upgrade its not working. there are 6-7 queries out of which only one of this on is not working. the query is to fetch the records from sales invoice header,sales invoice line, customer, item .
Hi Jagjeet, Can you send me the query at rkjais75@rediffmail.com