SetOption("Confirm Action Queries") not working

[Mark]

A2000

I have import routines that do a lot of appending and deleting. First
I was using SetWarnings False to allow my vb code to run w/o system
warnings. However that function stopped working for unknown reasons
(both via code and macro).

I tried SetOption("Confirm Action Queries") False and it worked
initially but the confirm delete/append boxes are still popping up.
I've stepped through my code and it is indeed clearing the check box
on the options/edit menu, but the warnings still pop up. What is
unusual is that if I manually clear the options check box, the
warnings are surpressed, but not when it is done by code. I've
compacted/repaired the db just to see it that would have any affect to
no avail. I don't get any debug errors.

Any suggestions.

TIA,
Mark

 

[Gina Whipp]

The only thing that comes to mind is somewhere you have SetWarnings True and
no SetWarnings False.