Alert or Message Box on Data Change within Query or Table

[HelpMePlease]

SQL backend. Access 2010 frontend. Linked tables via ODBC.



I have ONE column (bit) type that users constantly mess up. Is there a way to have a function or macro which will display a message box anytime data is changed?

It is easy to display a message within a form, but what if someone is working directly in a linked table or query?

[June7]

Why are users working directly with tables and queries?

Starting with 2010, Access tables have data macros but don't think they can be used with links.

Might be able to use SQL triggers.

[HelpMePlease]

Why are users working directly with tables and queries?

Because we allowed them to years ago and they are spoiled at this point. Maybe not the best answer, but that is the honest answer.

I will quickly brush up on "data macros" and see if that will do what I need. Thanks.

[trevor40]

Time to change, if they want accurate data they have to accept they should not interact with the tables directly anymore, then use form code that checks input and displays a msg if it's incorrect.

[June7]

Right, who is 'them' - the Boss - and who is 'we'? The Boss needs to understand the issue and make decision best for the business and everyone else falls in line.

[ipisors]

There simply is not decent advice that can be given, given your situation. You shouldn't ever develop an application, then give users access to the guts / design of the application. That defeats the entire purpose of developing apps and of GUIs.

Ask the user: "How can I be responsible for an application if I'm not allowed to safeguard its design??"

I would literally tell them that once the app is first created, no further troubleshooting/saving their rears will be done on the application because they have removed me as developer from the ability to maintain it. If that's unacceptable to them, I'd reconsider my employment there. (quite seriously). It would be as silly as a surgeon working at a hospital where the hospital management insisted on allowing the patients to use the scalpel on themselves during surgery because they were spoiled, or because it was fun.