This just can't be done...can it?

  • Thread starter Thread starter Joshua A. Booker
  • Start date Start date
J

Joshua A. Booker

Hi,

Does anyone know how to release the lock on a reference mdb without
restarting access? When I remove a reference programatically, access still
has a lock on the file.

Same appears to be true for the built in wizards.

TIA,
Josh
 
Josh,
It has been a couple of days and I see nobody has responded, so I thought I
might take a crack at it... The first question to come to mind is how is this
code being executed? Is this some automation you have running? Is everything
in module / code or are you using macros? When the code completes its task
are you using DoCmd.Quit or are you using Application.Quit ? etc... If you
were to supply some more detailed information there may be more responses...
It has been my experience that you want to use Application.Quit and stay away
from Macro's... Hoping to help...
Take Care & God Bless ~ SPARKER ~
 
This is not automation. I set references to other mdbs using
addreferencefromfile fuction then using references.remove I remove the
reference to library mdb. After doing this, Access still has a lock on the
library db as witnessed by the presence of the ldb file. This is true until
I restart Access.

Wwhe you use the Access wizards, locks are present on the wizards mdes until
Access restarts as well. This leads me to believe releasing these files
completely can't be done.

Does anyone know this for sure?

Josh
 
Back
Top