Form seems to have table locked even after closing.

[isladogs]

FWIW, I used to decompile using a shortcut. Nowadays I decompile using a right click context menu which also allows me to compact / open exclusively / simulate runtime / code sign a project etc

 

[MajP]

FWIW, I used to decompile using a shortcut. Nowadays I decompile using a right click context menu which also allows me to compact / open exclusively / simulate runtime / code sign a project etc

View attachment 120156

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

 

[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

 

[Pat Hartman]

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

We haven't seen your code. We don't know whether you are trying to delete the table from the form that had the table open or if you closed the form. But SOMETHING has the table open so you need to go through everything carefully until you find what it is.

 

[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

 

[Pat Hartman]

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

No. I have to use a shortcut

 

[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.