Updated query reverts back to old query when database reopened

[marydn]

I sure hope someone can help me out. I am working in an Access97 database that was written by someone else. I changed a query and everything seemed to work fine. However, when I close out the database then reopen it the query reverts back to its old self. Can anyone clue me in to why something like this might occur????

THANKS!

 

[LonnieJohnson]

It could be that the query is created in a module thru a query def procedure. Is there an AutoExec or code that automatically runs when the dB is opened?

Just a shot in the dark... B-) ljprodev@yahoo.com
ProDev
MS Access Applications

 

[Aivars]

Hi!

Check On Load, On Current, On Open, On Activate procedures of form!

Aivars