Suggestions on troubleshooting QueryDefs in Access 2000

Question

Access seems to hang when it executes a specific querydef. If I pause the code before it executes, manaually run the querydef and then start the code after it calls for the querydef it runs fine. There is something with Access calling the querydef that just kills it's performance.

The code itself is and has been fine for years. This seems to be a recent development...

Here's the code:

Set qdf = db.QueryDefs("qryPostTeachers")
qdf.Parameters("currentPostID") = lPostID
qdf.Execute dbSeeChanges + dbFailOnError

Answer 1

JetShowPlan may help.

-- http://msdn.microsoft.com/en-us/library/aa188211%28office.10%29.aspx