title: Access 2000 form is slow to load over a network
body: <p>I have an Access 2000 database that sits on a peer to peer network. (All computers are connected via ethernet 100 to a simple 4 port switch)
  The database is designed with a back-end and a front-end.
  There are 2 users that connect to the back-end via the network. One user connects to the back-end directly as the back-end sits on her computer.
  All the computers are fairly low spec, with either 500 meg or 1 gig of ram</p>
  
  <p>I have one form, frmInvoice, which is based on the table "tblInvoice" There are about 60,000 records in the table. There is also the table "tblInvoiceProducts" which is linked to "tblInvoice". There are about 150,000 records in the table "tblInvoiceProducts".</p>
  
  <p>When I open form "frmInvoice" on the computer which hosts the back-end, the form opens very quickly. However if I open the form on one of the other computers it is very slow to open. However, once opened, record navigation is fast.</p>
  
  <p>I think the problem is that when the form is opened, Access opens the entire table and all the records are accessible. Am I correct in this assumption?</p>
  
  <p>I need to rectify this problem and welcome all suggestions.</p>
  
  <p>I am going to install a D-Link DNS-323 2-Bay Network Storage Enclosure and store the back-end database on this as this will improve security / data protection.</p>
  
  <p>Thanks in advance</p>