1

I am facing issue related to the performance in MS Access 2010, calling procedure via Pass Through Query, ms access screen hangs. If i run procedure it took one hour to complete and come out successfully, but if i am running through vba than screen is not responding.

    Private Sub abc_Click()

    Dim db As Database Set db = CurrentDb()

    DoCmd.OpenQuery "PRocedure", acViewNormal, acEdit   
End Sub

I am using User DSN enter image description here Please suggest me some good way so that ms access screeen does not hang and it comes out when procedure completes successfully.

ravi chaudhary
  • 617
  • 4
  • 15
String
  • 3,660
  • 10
  • 43
  • 66
  • It looks like you have timeout issue. 1 hour it's very long time. Am i right that when you run procedure from some sql tool it works fine? Does procedure return something? – Sergey Jul 31 '15 at 22:48
  • @Sergey: In pass through query i have set timeout as 0. Yes, procedure is running fine with sql tool. Procedure is not returning any thing. I am commenting on behalf of the user. Please suggest some way to get out from this problem – ravi chaudhary Aug 03 '15 at 08:36

1 Answers1

0

As procedure doesn't return anything you can use async execute using ADODB.

You can find some details here: Running multiple async queries with ADODB - callbacks not always firing

When you run your procedure you can track process via periodical requests to progress table. Of course this procedure should be modified to show progress.

Community
  • 1
  • 1
Sergey
  • 244
  • 1
  • 7