I'm having a problem similar to Q.10164777. I've followed all the techniques described in that question to try and solve my problem, but it persists.
Here's the deal: I have a make table query that creates a table called tblMusiclst. It specifies recordlocks - edited record. I have a form whose record source is that same table. There's a button on the form that closes the form, then executes a the above mentioned make table query for tblMusiclst. When the make table query runs I get the run time error 3211.
It acts like the tblMusiclst is not being fully closed when I execute the close acform for that form. Any ideas as to what's going on here or how I can get around it?