Runtime error 3211. Table is already in Use. When deleting table.

[pedie]

Hi, I have a combobox whose rowsouce is in a table column..
When i try to delete the table it says it is locked by another user. How can i make this work. I need to delete the table and import it again at times even when the form is open.

Thanks in advance.

 

[Kreszch68]

Hi Pedie,

you need to close the form and the reopen the form.

You can use the code below, you need to place this in a module, not in the code of the form.

Public Sub ReopenForm(ByVal sFrmName As String)
DoCmd.Close acForm, sFrmName
'delete the table
DoCmd.OpenForm sFrmName, acNormal
End Sub

 

[pedie]

Kreszch68, thanks for the help....