I have inherited a MS Access database which connects to tables on a server at a different location. I am finding that queries take a very long time to run. Here are some questions:
Is there a name for this kind of configuration?
What are the inefficiencies of this type of configuration ?
What are my options for improving on it ?