How to force an Access database to process the data after their arrival?

Question

SQL

There is an Access DB on the server. Table Table1 receives data every hour. It is necessary to make sure that when the data arrives, the value is updated according to the average daily and entered in Table2.
Can the database be forced to execute a script when data arrives?

Answer 1

If you have a choice other than MS Access, I advise you to install something else - from MS SQL Server Express to Posgres, the main thing is to have a full-fledged DBMS. There you just set up the trigger and the transfer logic.
If you are limited to MS Access, then look for something to replace triggers with (again, you need to look at how they will be executed) or make a client on .NET / Delhpi that will perform the transfer.

Answer 2

The Access database must be open. We put the clock element on the form, in the settings we prescribe an interval, using it to check whether the data has arrived and processing - and here it is, happiness. The form must also be open.