I have a couple layouts that look at an SQL Server ESS view. More frequently going to these layouts or refreshing them locks up filemaker and I believe the sql database. There is an access database that is linked to this same set of sql tables.
Going to the layout and refreshing is simply going to the ESS View and sorting it.
Both the Filemaker Server and SQL Server are hosted on the same machine.
Any ideas of where I might start looking for a problem? I have been using the same set-up and layouts for over a year and this just started a month or so ago.