Error 3211 table locked

[Gasman]

Hi all,

I have attached a db with just two tables in it and the form that uses one of them.
I am getting the table locked error, but currently the only one using it.

tblUserParagraph will be a local table as suggested in another thread regarding my attempts at moving items between listboxes.

https://access-programmers.co.uk/forums/showthread.php?t=291744

The form (frmUserParagraph) does not have any record locks and is unbound anyway (at least at present).

Can someone please advise as to what I have done wrong?

TIA

 

[Minty]

You are deleting the table tblUserParagraphs, that is listed as the row source for lstAvilable which is locking it.

Catch 11tenty E11evn methinks...

 

[CJ_London]

in the form load even you are trying to delete a table that is being used by your two listboxes.

instead of delete table, You can try using

CurrentDb.Execute ("delete * FROM tblUserParagraph")
lstAvailable.Requery

but still coming up with another error - because you are trying to use a make table query - change it to an append query