Propriedade LogMessagesLogMessages property

Aplica-se ao: Access 2013 | Access 2016Applies to: Access 2013 | Access 2016

You can use the LogMessages property in an SQL pass-through query to specify whether messages returned from an SQL database are stored in a messages table in the current Microsoft Access database.You can use the LogMessages property in an SQL pass-through query to specify whether messages returned from an SQL database are stored in a messages table in the current Microsoft Access database.

Observação

[!OBSERVAçãO] The LogMessages property applies only to pass-through queries.The LogMessages property applies only to pass-through queries.

SettingSetting

The LogMessages property uses the following settings.The LogMessages property uses the following settings.

ConfiguraçãoSetting Visual BasicVisual Basic DescriçãoDescription
SimYes True (-1)True (-1) O Microsoft Access armazena mensagens retornadas do banco de dados SQL em uma tabela de mensagens.Microsoft Access stores messages returned from the SQL database in a messages table.
NãoNo False (0)False (0) (Padrão) O Microsoft Access não armazena mensagens retornadas do banco de dados SQL.(Default) Microsoft Access doesn't store messages returned from the SQL database.

Você pode definir essa propriedade usando a folha de propriedades da consulta ou o Visual Basic.You can set this property by using the query's property sheet or Visual Basic.

ComentáriosRemarks

O nome da tabela mensagens onde as mensagens retornadas são armazenadas é nomedousuário - nn, onde username é o nome de logon do usuário que executa a consulta passagem e nn é um inteiro que aumenta em incrementos de 1, começando em 00.The name of the messages table where the returned messages are stored is username - nn, where username is the logon name of the user running the pass-through query, and nn is an integer that increases in increments of 1, starting at 00. For example, if user JoanW sets the LogMessages property to Yes and receives messages from an SQL database, the messages table will be named JoanW - 00.For example, if user JoanW sets the LogMessages property to Yes and receives messages from an SQL database, the messages table will be named JoanW - 00. If JoanW receives messages in another Microsoft Access session (and the first table hasn't been deleted), a new table named JoanW - 01 is created.If JoanW receives messages in another Microsoft Access session (and the first table hasn't been deleted), a new table named JoanW - 01 is created.

Observação

[!OBSERVAçãO] Error messages from SQL Server aren't stored in the messages table.Error messages from SQL Server aren't stored in the messages table.

Confira tambémSee also