Link to home
Start Free TrialLog in
Avatar of Warren_R
Warren_RFlag for Australia

asked on

Access 2010 SetWarnings in menu?

Hi, this seems like a stupid question but:
- I have taken over from another developer.
- I use his machine, but with my own logon.
- In the main DB in use, his logon supresses Access warnings, but mine does not.
- I don't want to change anything including adding SetWarnings = fase to any procedures.

So my question is, why does his profile supress warnings, but mine does not? Can I switch this off within the settings of Access and not change anything in code?

Thanks, Warren
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Warren_R


MX - Perfect!

Access 2010 is Options > Client Settings > Confrim > Action Queries

Some settings are stored in the current database (like showing the default shortcut menus), others in the user's registry (like confirming record deletion).

This being said, the user's settings should not have any effect on the behaviour of the database. I suspect that DoCmd is used where it shouldn't (SetWarnigs is a DoCmd property). Typically, DoCmd.RunSQL and DoCmd.OpenQuery (for action queries) should not be used.

We can help you remove those from your code if you show us the offending lines.