I have been having the same problem as described in this thread. Have you ever come up with a definitive solution?
I have found out, in a database that has been working for years, that I am able to add and delete through access tables, but the odbc times out in a form. Also, there seems to be a pattern. The table structure is from a workorder table with about 45 fields with a parent customer list. There are about 2000 customers with about 25000 work orders. Its seems that those customers with about 145 workorders receive the timeout error.
I am still working on other solutions like putting in more indexes using Management Studio Express and I hope it will work.
Any Advice would be great