Form seems to have table locked even after closing.

[isladogs]

What is that? Is that your add-in or someone else's add in? Or is that outside of Access?

Its an Explorer extension that can used to run any Access command line switch and could be adapted to provide similar functionality in any other Office app. Its based on an excellent utility by Daniel Pineault and I can't recommend it enough as an excellent time saver

Windows Explorer MS Access Database Right-Click Context Menu

MS Access utility demo database which creates a Windows Explorer context menu for MS Access files to directly compact, decompile, exclusive and/or runtime.

www.devhut.net

I've mentioned its use in a few articles such as

Access Command Line Switches

This article lists the command-line switch options available for Microsoft Access.

www.isladogs.co.uk

Command Line Project Signing

This article describes the new command line project signing feature available in Access 365. It is useful for quickly signing a batch of VBA projects in succession without needing to open each app first.

www.isladogs.co.uk

 

[isladogs]

I just add the commands I use all the time to the toolbar.

Yes but you can’t add decompile to the toolbar/ribbon

 

[The_Doc_Man]

This is probably implied in some of the utilities being named here, but the first place I would look is the DBEngine(0).Databases(0).Recordsets collection, which you might be able to parlay into seeing if the problem is a dangling recordset. Even if it is a literal SQL recordset, you should be able to see the fields it returns.

 

[Gasman]

I would be looking in Task Manager in case any Access processes still exist?

The number of times, something fell over and I still had an errant access process?, well let's just say a few times.