> Client uploads Access Db, then script runs a qry to grab zip, loop > thru SQL to find assoc. Dealer, it emails the dealer and then updates > the Access. Problem is it times out. I'm looping 50 records at a time > and thought this would cure it, but doesn't. The loops are using the > original qry - would I need to run a new qry for each time it loops > through the 50? > > Long day, appreciate any help out there. MY SOLOUTION: I'm replying to my own post, maybe it will benefit someone else. I didn't want to increase the timeout since I work on a shared server. I revised the procedure and it functions well. In a nutshell. I set a new field in Access: [Process] Run qry GET: max rows 50 where process <> 0 Loop through the 50. and set [Process] = 1 during the update. Follow loop with qry GETNEXT: max rows 50 where process <> 0 check GETNEXT.recordcount. If recordcount NEQ 0 use cflocation to run this file again. Else Done. As an aside, it's simple and I use it in FuseBox scenario.
Thanks to those that replied- this forum is a great source of information ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
