The database engine could not lock table "x" because it is already in use by another

[lwilliams]

The database engine could not lock table "x" because it is already in use by another

Help!... I'm new to this stuff...

I have a query named "qryProgressTotal". It is a make-table query that is supposed to create a table called "ProgressTotalPerStudent"

I open the query once to create the table as follows:

stDocName = "qryProgressTotal"
DoCmd.OpenQuery stDocName, acNormal, acReadOnly


This runs fine the first time, but if I run it again, it gives the error message noted in title. :banghead:

I have tried closing the table prior to running the query a second time, but no change; same result :banghead:

DoCmd.Close acTable, "ProgressTotalPerStudent", acSaveNo


I have tried closing the table AND deleting the table: sAME RESULT:banghead:

DoCmd.Close acTable, "ProgressTotalPerStudent", acSaveNo
DoCmd.Close acQuery, "qryProgressTotal", acSaveNo
DoCmd.DeleteObject acTable, "ProgressTotalPerStudent"

Any ideas!