Event Question

[Wheat]

I have a db that is automatically updated from data
imported from excel. I've setup a couple of queries based
on the table. I've also setup an e-mail to be distributed
based on the data returned by the query.

Right now I have to run the queries manually. Is it
possible to create an event based on when the table is
updated or are events strictly for forms and reports? If
it is possible, how do you create an event for the table?
Thanks.

 

[Allen Browne]

No. Access (JET) does not have events at the table level (called triggers in
other databases).

If it is crucial, you may be able to store the data in MDSE (or whatever the
call SQL Server Lite these days).