MS Access split database queries?

Question

When the frontend of a MS Access db queries a MS Access backend on another machine over the network, does it pull in the whole table/database/file, or does it have some way of extracting just what it needs from the backend, thereby lessening network load.

Answer 1

Hello Maia, Since the back end only has the tables in it all the processing is done in the front end. That being said you could use queries to limit the fields used in reports and forms.

HTH

Jeff