ms access - sql timeout on view -


we have access application in our office takes data sql server management studio 2012 different views (order tables joined other tables different companies) , put them in single access table statistics. problem when view becomes complicate, if execute view design gives error after 30 sec , access gives same error when open view access cannot transfer data.

i changed timeout query , designers if execute query view have no problems but timeout has no effects on view.

here view:

select     dbo.ordiniqdopolib.dataconsegna, dbo.ordiniqdopolib.fornitore,            dbo.ordiniqdopolib.hotel, dbo.ordiniqdopolib.ordine,             dbo.ordiniqdopolib.prodotto, dbo.ordiniqdopolib.numeros,             dbo.ordiniqdopolib.costounitarios, dbo.ordiniqdopolib.costototales,            dbo.ordiniqdopolib.consegnato, dbo.ordiniqdopolib.iddoctrasp,             year(dbo.ordiniqdopolib.dataconsegna) anno, dbo.ordiniqdopolib.napoli,             dbo.ordiniqdopolib.contrnap, dbo.regdoct.ndoc,             dbo.ordiniqdopolib.id, dbo.ordiniqdopolib.utenza,             dbo.ordiniqdopolib.compperiodo, dbo.ordiniqdopolib.companno,             dbo.ordiniqdopolib.dataov dbo.ordiniqdopolib  inner join dbo.regdoct     on dbo.ordiniqdopolib.iddoctrasp = dbo.regdoct.id (dbo.ordiniqdopolib.fornitore <> 'inventario napoli') ,        (dbo.ordiniqdopolib.ordine > 0) ,        ((dbo.ordiniqdopolib.consegnato = - 1) or (dbo.ordiniqdopolib.ordine < 0)) ,       (dbo.ordiniqdopolib.contrnap = 0) 

any suggestions on how avoid 30-second timeout?


Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -