query; add records notification

[CBA88]

We recently converted our database from Access 97 to 2003. My coworker uses
a query that took spreadsheets and added/altered records in the database. In
Access 97, there was a notification box that would appear when running the
query stating something to the effect of "You are about to add ## records to
your database." She'd used that notification box as a check against the
numbers she was expecting to be added; apparently it doesn't appear in '03.

Is anyone aware of an option to toggle that notification on in Access 2003?

(I realize this question is somewhat lacking in detail, but this is all the
info I have)

Thanks in advance for any suggestions.

Regards,
Brad

 

[Jerry Whittle]

It is there in Access 2003. Go to Tools, Options, Edit/Find tab and check
that both Confirm Record Changes and Action Queries are checked.

If the are then someone has probably Set Warnings off. Once toggled off,
either in code or a macro, it will not come back on until someone Set
Warnings to True or you shut down and restart the database. You may need to
look through all the code, including code behind forms, and macros for Set
Warnings to make sure it is turned off.