Auto run Query on table update

[kamitaken]

Hi everyone.

I'm pretty new to Access and i need some help to run auto execute query.

I have a Table A.

I have another program interacting with it and updating it's fields and adding new ones automatically
set by certain time everday.

I need to do the following.

When a new field is entered into the table i need to automatically run a query which will copy that field to another table (new field).

All this is done automatically so i need this operation to be done automatically as well.

How do i do this ?

Basically i need a solution on how to trigger a Query when the table has been updated or a new filed has been added to it
that i have been set it to execute every 4.am everyday.

But what happend is,it kept automatically execute wrongly in time and keep duplicate the same field in the table.

Please help out.

 

[Galaxiom]

I assume you are adding new records rather then new fields. (If you are indeed adding fields to the table you have better rethink the whole data structure.)

It would be much better if the same table could be shared by both applications so that they look at the same data. They should be able to query what they each need from the same table.

If that is not possible and you have to run the synchronising query then your task really should be be aware of which records are new. If necessary add an Autonumber field to the source table and outer join to the destination table on that key. The update query will then add and update new and changed records.

The AfterUpdate procedure of the Form can be used to run the query when a record is added or changed.