Hi all I have a Access 2007 database split Front End and Back end with a few a handfull of users which runs slow when Back end hosted on a LAN. Im pretty sure it's a result of the LAN being heavily used. It takes over a minute just to open. The Front End has a main form that auto opens when at the start and has a handfull of subforms that have modules driving them using Form_Current(). Does Access check everything on load to see if all the connections are in place? And is there anything I can do to speed things up?
PS. SQL Server not an option.