Linked Table Manager enhancement - Trigger events
I understand the Linked Table Manager enhancements are on the MS Dev Team's agenda.
I'd like to suggest that the enhanced Linked Table Manager expose a COM interface with EVENTS that a VBA app can detect and respond to.
This could be of benefit to All Apps in an SDLC sense (we can query the tabledefs to connection info already, but can't detect when they are changed via the LTM or otherwise), and can allow some apps to react to protect the security or integrity of their data/connections.
If the Linked Table Manager could expose events like:
LTM Close (with a parameter reflecting if changes were made or not)
LTM Table connection BeforeChange (with the TableDef object to be changed as a parameter, with perhaps a Cancel option on the event)
LTM Table Connection AfterChange (with the TableDef object as a parameter)
LTM Refresh event
LTM Connection Fail (when changing/refreshing) event
I'm sure other might be worthwhile too, but those should cover the basics.
(Of course, it'd be nice if the Ace DBENGINE exposed a related interface WithEvents the we could trap and respond to via VBA also...)