Building an application wrapper

[Bob Segrest]

I have an Access application.

I want to write a VB application that will...

1. restore the Access data file
2. launch the Access application
3. wait for it to close
4. and then backup the data file

Restoring, backup and launching Access are easy.

The problem is getting the VB application to wait for the Access application
to close. Can anyone suggest how I might do this?

Bob Segrest

 

[Tran Gia Loc]

Hi Bob,
I can suggest you 2 solutions:
1. Your app should intercept a certain event triggered
by Access during its shutdown.
2. Write a small add-in intercepting a certain event
triggered by Access during its shutdown. Indeed, Office
programs always notify their add-ins during their shutdown.
When receiving this notification, your add-in immediately
alarms your app.
Tran Gia Loc.