I have an access FE application that is linked to 50% access tables and 50% sql tables.
I run sometimes in situations where I have a non responding running query.
very often its joining Access and SQL tables in one query.
What is the safest way of stopping it?
a-at the clients pc call task manager and end the access non responding app.
b-from SQL SSMS kill that transaction.