Re: changed queries save automatically

Hi Jerry,

I have been researching this thread topic in both the general access and
access.queries groups. Although your logic seems correct, I have had this
problem show up in mutliple databases and I never have used the SetWarnings
command and always have the option "Confrm Action Queries" checked on. In
fact, when I observe this behavior I have checked the "Confrm Action
Queries" and it still shows checkd on.

Either something else is turning off warnings or we're dealing with a bug
(that wouldn't be a first). BTW - I never experienced this before Access
2003 and have used Access since Office 95.

Any more thoughts?

Don Small


"Jerry Whittle" <JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6950D177-F0CF-4B8C-8C92-3EAAB7C1C800@xxxxxxxxxxxxxxxx
Yes I have and it's not what you think such as corruption. Most likely in
a
macro or code someone has Set Warnings to Off but forgot to Set Warnings
back
on when finished. Often people turn the warnings off when doing something
like automatically appending a lot of data or deleting records so that
they
don't get bugged with all the "do you really want to" messages.

Compacting and repairing closes the database and reopens it. By default
when
the database opens, Set Warning is on until someone turns it off. You
might
even have something running from the startup form or the autoexec macro
that
turns off the warnings.

If I'm right (it's been known to happen) about the time that your changed
queries save without asking, you'll also find that changed forms and
reports
will do the same thing. Even closing the database and reopening should fix
it
unless it's a startup form or autoexec macro kicking in.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"staticmaster" wrote:

I am working in Access 2003 SP2 and I have to continually Compact and
Repair
the database, because I do not always get the popup asking if I want to
save
a changed query. I like to open an existing query and do a "What If"
change,
but don't want to have that change saved when I close the query.
Sometimes I
can work in the database for a while before it saves changes
automatically.
Has anyone else run into this problem.



.

Relevant Pages

  • Re: changed queries save automatically
    ... Then I modified another query and was ... macro or code someone has Set Warnings to Off but forgot to Set Warnings ... Compacting and repairing closes the database and reopens it. ... Even closing the database and reopening should fix ...
    (microsoft.public.access.queries)
  • Re: Macro to Run Table after batch processing
    ... external file and the destination table, and copy the make table query. ... SetWarnings False ... Finally, use Windows scheduler to open the database as required, Everytime ... this happens the autoexec macro will fire, run the action query, and close ...
    (microsoft.public.access.macros)
  • Re: Automated Routines
    ... A Delete query is what will do the job; an Autoexec macro to run it ... everytime you open the database might be a convenient trigger to run it. ... > I need to create an automated routine in the database that automatically ...
    (microsoft.public.access.modulesdaovba)
  • HELP WTH AUTOEXEC MACRO
    ... Can someone assist me with writing the little code that is needed to ... run an update table query each time the database is opened? ... I've been able to glean from this group, the Autoexec Macro looks like ...
    (comp.databases.ms-access)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
Loading