Changes to queries not saved

  • Thread starter Thread starter Pete S
  • Start date Start date
P

Pete S

I have encountered problems in the past with Pass-through
queries where changes to the query are not saved. Make a
change run the query and the original data is returned.
Look at the query and the changes have not been saved. I
am experiencing similar problems with 'normal' queries. I
can be less sure that this is the same as the pass through
problem but on several occasions changes made revert to
their original status.

Am I going mad or is this a known problem?
 
Pete

Is there a chance your database has turned off warnings?

Create a macro, select the SetWarnings action, turn the warnings On. Run
the macro.

Does your query issue still exist?

(P.S. You could also turn SetWarnings to On in the Immediate Window, if
that's more convenient.)
 
In my macros and in the code I turn off the warning
messages as I am loading and deleting lots of data.
Are you suggesting that I have left the messages off,
closed a query without hitting save and therefore not been
prompted for the save message.
 
Yes.

Pete S said:
In my macros and in the code I turn off the warning
messages as I am loading and deleting lots of data.
Are you suggesting that I have left the messages off,
closed a query without hitting save and therefore not been
prompted for the save message.
Click to expand...
 
Back
Top