Events raised by Access 2003 (or lack thereof)

[Dave Mc in Cork]

I'm developing a VSTO add-in for Access using the PIA for Office 2003. There
seems to be a distinct lack of events in the Access object model - the
'Application' object in particular. The only events I see documented for
Access relate to forms and reports. My add-in needs to perform certain
actions in response to the user changing the current database, but there
doesn't seem to be any way to get a notification that this has occurred. In
contrast, the equivalent add-ins I have written for Excel and Word use the
myriad events raised by these applications to handle documents being opened,
saved, etc. Am I missing something? I am very keen to avoid having to resort
to a background thread in my add-in that polls Access to determine if the
current database has changed.

Btw, this is a re-worded version of an earlier posting to an MSDN VSTO
forum. The moderator of that forum advised that this would be a more
appropriate place to post my question.

 

[Douglas J. Steele]

What do you mean by "changing the current database"?

Since code only exists in a database, changing the database would mean that
your original code would have stopped running.

 

[Dave Mc in Cork]

As my original post noted, I am writing an add-in for Access. This is not VBA
code running within a module, form or report in the database. Add-ins are COM
components that are loaded by Access on startup and unloaded just before it
exits. As such, they operate completely independently of any one database.