Unlike global variable queries, which can view but not change any settings, a user or client application can issue a set statement to change those values that affect the client connection—but only the current connection. In other words, these values remain in effect only for the duration of the client connection or until another set statement is issued.
Access service set statements are not case sensitive. To set an access service configuration property value or processing value for the current connection:
set { property_name | processing_name } value
where:
property_name is the name of the configuration property.
processing_name is the name of the processing option.
value is a valid value for the configuration property.
This is a set statement for the Client Interaction property SendWarningMessages:
set SendWarningMessages {no | yes}
For a list of the configuration properties that you can use set statements to query and change, see Appendix A, “Configuration Quick Reference Table.”
