I have a table in Access linked to a hosted SQL Server DB. It is one of many tables in the DB but it is the only one that randomly, at least once per day, seems to lock up. When users try to add a record they get the ODBC linked table message with a timeout.
It is a standalone table with no relationships anywhere else. I do not host the database so don't necessarily have access to logs etc.
What can I do to either stop this happening, or see what the problem is?