2002-2003: Identify Access population event

A S 0 Reputation points
2023-02-24T19:52:46.9933333+00:00

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

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.