Closing Open Databases

60 pts.
Tags:
Access Database
Exchange System Manager
Microsoft Access 2000
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!

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following