If it's in Access, there isn't necessarily any SQL Server required at all, so this may be the wrong forum for you, but if you're talking about an access front end interface with a SQL Server backend for example, then you can set up various notifications to go out to users based on certain conditions being met (I'm assuming this is what you're looking for?)
You'll have to be more specific about what you really need, but you can create operators in SQL Server to send out email (etc) notifications to specific people (admins). Among other things, you can either capture specific events and report on them on a schedule, or you can attach a trigger to a specific table to automatically fire out an alert at a certain specified condition.
If you give a bit more info, I may be able to help, but if it's entirely in Access, then I probably won't be much use to you.
|