I support an Access 2000 app with SQL 2000 back end. Runs on a LAN with Terminal Server for about half the users. About 40 users total. This program continues to lock on three of the tables. Users then get ODBC timeouts on any function that references any of those 3 tables. It's easy to clear in Enterprise Manager but I have no idea on how to track it down. If I go to process info about 80% of the processes are under host 'ACER' which I cannot figure out. ACER is always involved when there is gridlock. None of my terminal server users have a computer with that name and none on LAN workstations are called ACER. If I try to send a message via Process Information I get an error. I cannot ping ACER.
All the locks are 'select' statements.
Any ideas as to where to begin?