About trigger

[hanski]

Hi.

My application works on Accessa 2000. Alla my data are in SQL server,
so there is an ODBC link between them.

I have a table which includes for instance names of countries.

Is it possible to creater some kind of trigger or something else to
automatically popup a message box to each user, when someone adds a
new coutnry to the database? User would not have to go and see,
whether there are new countries in database, but the application tells
the user when new countries are added.

thanks

Hannu

 

[Guest]

I have a suggestion that may work.

With the country name you would need a checkbox (default value set to
"true") and a date field (default value set to "=Date()"). So when you enter
a new country you know the date in which it was entered.

Create an update query so that if the difference between the entered date
and today's date is greater than a certain amount then change the checkbox
from "true" to "false" (I think this will depend on how often the database is
used). This query would have to be fired when the database is closed (with a
command button)

When the database is opened you want some method to check if there is at
least one checkbox set to "true". If there is then you fire the popup. Though
I wouldn't be too sure how to do this.