Unshowing confirmation messages

As we have already seen, Access will advise us of the changes made when we run an Action query so that we can cancel the operation if we choose. On occasions these messages will not be necessary and if we want, we can configure it so that we are not asked for confirmation.

We can achieve this by changing the Access options.

For this we will need to drop down the Tools menu and select Options...

The Options window will appear, click on the Edit/Find tab.

In the Confirm section we can:

Activate or disactivate the Record changes messages, these are the messages that appear when it is about to

delete records

edit records

append records

insert into a new table


Activate or disactivate the Document deletions messages, messages that appear when objects are deleted from the database (tables, queries, forms,...) e.g:


Activate or disactivate the Action queries messages, messages that appear when we open an Action query from the database window, e.g:

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.