I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn.
Anyway, this product has multiple mde's that all are "called" from a main System Manger.mdb. When System Manager opens a form in one of the mde files that mde is now open, and has a related ldf.
I am trying to write a script (in a module) to check to see if updates are available, and if so, copy new versions of the mde file(s) down from the server to the local hard drive. However, if one of these files is open, the copy files (obviously).
How do I check to see if these files are in use, and if so, close them so I can copy a new version in?
Thanks in advance!