Application Not Responding

[Idris]

Can anyone help me here...........

I have develop a Inventory application and its now functionaling well - Basic concept off the Inventory module is to process approx more then 50,000 records (sales/purchase) date wise product wise with lots of other stock categorization etc etc

when clicked Process starts the execution and after a moment i see that the Mircosoft Access Not Responding in the title bar - while actually its processing the data in the background

Quest 1
how do I control this message?

Quest 2
Is there a way that the execution if exceed the certain time limit it should immediately warn or terminate the process - If here i have to use the timer event over here it will cripple the entire process that will take more time to process the data

Quest 3
Is there any API solution to this queries

 

[tkpstock]

If it takes that long to process 50,000 records, you should look at your algorithm/query design to reduce that time and eliminate the problem. Can you post an example?

Make sure you are not getting into an infinite loop somewhere.

I don't know of any procedures to terminate or timeout a query process once it starts - maybe someone else has a suggestion on that one. If you are looking to the API to work around the limitations in Access, maybe Access isn't the proper tool to be using in this instance (just my opinion).