Since you want a real-time system, if a change is made it is reflected online
immediately, then you would need to build a web application. MS Access is
not the proper tool for this type of application. You would need to hire a
web developer that could build such a system using tools such as MySQL, Sql
Server, PHP, ASP, .Net....

I have create numerous such applications, and depending on your needs, it
can be a fast and simple thing to do or a complex project that can take
months to complete. It all depends on the bells and whistles you need to
incorporate into the final product and whether you have already taken the
time to truly determine what you want (from a to z).

Also, any web app. can easily incorporate your need for automated e-mail
notifications...
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Lester" wrote:

I am a USA Track & Field Official. I am trying to set up a scheduling system
so officials can visit our website to find out what track meets they are
scheduled for. This central schedule will be instantly updated when
commissioners make changes. The idea is to send out email automatically to
affected officials whenever a change is made.