The orphan lock file is probably a result of the latest bug released by MS updates.No search code, using the built in search from Access. Wondering if it's a Windows 11 issue?
This seemed to happen around then. Also, some other odd things too. When closing Access, it sometimes leaves a lock file behind.
You probably have two different problems. It's possible that updating to Windows 11 was a bit premature as it's not yet a settled quantity.I have a macro that has a message box and then opens a form. It only shows the message box and does not open the form.
When I remove the message box, it then works and opens the form. All of this after windows 11
Check the two links I included. They have all the known information and fixes and workarounds to date.Any update on that fix?