Just in case you were interested in the task, I have an Access database (not by choice, but the political considerations have closed that discussion) where the functional requirement is in reality a Record Insert Trigger on one particular table. There are multiple applications in play.
What I'm hoping that I can do is create a separate mdb file with just that one table, which now an autonumber field for my exclusive use, and link to that from the main mdb. Then place a watch on the mdb file with the single table, and upon notification, use the autonumber to determine if the file update was the result of a record insert (don't care about record updates), and if so, take care of business, on that and all newly inserted records as I can foresee, although small, where multiple inserts can be so close together that I can't assume that one message means only one new record.
Obviously, the key element is that when one of the other application performs a record insert, that the OS will detect the file change and trigger the event to let my app do what it needs to do.
I'll let you know with any luck sometime on Monday.
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein