0

I have the application which use my locally stored access database.

One option is very interesting to me. I would love to know which query is run in background to get data on that option.

Something like 

Query sniff
Query profiller
Query monitor

Is there any way to extract that query ?

PyDeveloper
  • 309
  • 6
  • 24

1 Answers1

1

No, there isn't. An Access database is a file, not a server. Any profiling needs to be done by the application executing the query.

This question has some answers on how to get the total time a query is running, but you're likely limited to that. This answer shows you how to get the execution plan for queries, but it requires registry tweaking

Erik A
  • 31,639
  • 12
  • 42
  • 67
  • And please note Access is not multithreadable, so you don't rely have anything running in 'background' – marlan Nov 29 '17 at 23:50