Suggestions on troubleshooting QueryDefs in Access 2000

Access seems to hang when it executes a specific querydef. If I pause the co开发者_如何学JAVAde 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

JetShowPlan may help.

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