Could not lock Table error

[Lorlai]

I have been getting the following error:

Run-time error '3211':
The database engine could not lock table 'Temp' because it is already in use by another person or process.

I have tried closing the table through vba:

DoCmd.Close acTable, "Temp_WIP"

But still get this error. I am not sure why this occurring. There are no forms that use this information, and no queries that utilize the temp file once the files have been appended to the master file. Is there a way to quickly and easily see all objects that are using the Temp file? Or does anyone have advice to figure out a way to end this error?

Thank you for your help!

[June7]

You can try the Tables and Related view on the Navigation pane.

[Lorlai]

This confirms that nothing is associated with the table, the Temp table appears alone. Is there another way to look?

[June7]

I use an add-in called Rick Fisher's Find and Replace to search database. Costs about $50. Saved my butt more than once.

It is possible you have a corruption issue. Can you copy this table? Can you delete it?

[Lorlai]

I can copy and delete the table manually, but cannot do it through the code I placed in the first post. If it is a corruption issue, would recreating the database be the best option?

[June7]

Your code is to close, not copy or delete. You also tried code to copy/delete table?

Sometimes just building a new object and deleting the old one resolves corruption. Sometimes have to create new db.

Have you run Compact & Repair?