2002-2003: Identify Access population event
I use manufacturing software that populates 2002-2003 Access at a certain point in the manufacturing process and then "flushes" the data out when that process concludes. (When the data populates, the user has the option to print reports before continuing) There is no user form entry into Access of any kind
My goal is to automatically trigger an event---whether query, VBA, macro---whatever works---when the database has populated.
I tried using "AutoExec" which didn't work; I am assuming Access doesn't actually opens during the population event or opens in some type of hidden mode that doesn't inform AutoExec.
My question is, is there a mechanism to identify when the database has left a Null state and automatically trigger an event when that happens?
Thank you