How to determine the creator of a temp table

[kpaull]

Using MS Access 2013, working on a clients database. I am still a junior at this There is a temporary table which a query is running against. I want to determine what is actually creating this temp table?

Any way to determine that?

Thanks,

 

[AccessBlaster]

There is a free tool called V-Tools with it you can do a "deep search" though code and objects.

 

[gemma-the-husky]

is the temp table showing a recent "created date"?

it might be a static table that is just cleared and repopulated, rather than being created afresh each time. The code would be slightly different in each case.

 

[kpaull]

Found it being created dynamically via a query.

Thanks all.