Database Response Time Recording

[492JQS]

Is it possible to to set up a table in an access DB that records response times for opening the DB, navigating between forms etc? I have a number of users based on a remote site and they are complaining about how slow the database runs, claiming it is unusable. When I visit the site and access the DB myself the response time isn't good, but the DB is far from unuseable. Unsurprisingly, the remote users claim that I tried it on a good day, and that it is usually much slower. What I want to do is gather some response time data automatically for an unbiased review.

Is this possible?

 

[stephen81]

I've knocked together a quick example of what you might use. It's not very well written and my naming conventions are non-existent. Unfortunately I haven't got time to tidy it up. Just open up one of the forms and use the command button to swap to the other form and back. The click time and form opening times are recorded in the table.