Mystifying behavior in access-db

[Tiger955]

Hi!

I have suddenly a very mystifying behavior in an access 2010 front-end which DELETES a certain pass-through query from time to time.

The query sends an sql-string to the sql-server and retrieves the data from the server.

The same structure of data-retrieving I use in many othere databases as well without problem.

I also created the disappeared query for new, using another name to store it in my database.

After almost every use of this query is vanishes.

Any idea?
Any solution?

Thanks your help.

 

[pbaldy]

My first thought is to search for code that deletes it. Control-F in the VBA editor will help with that.

 

[Tiger955]

As neither the datebase is new, nor the code in VBA is new, I am puzzled.
So there is no code who deletes this query.

 

[Tiger955]

I think I found the reason of deleting the query:

two events which runs at the same time used the same query. This might be the reason for the deletion. After changing this, the query does not vanish anymore.

 

[pbaldy]

I can't imagine why that would delete the query, but glad you solved the problem.