title: Deploying Access as a client-server application
body: <p>I'm using Access (2003 format) as a front-end with a SQL Server 2008 backend.  Each user already has Access 2003 or 2007 installed.  I'm curious as to the best deployment configuration to use for efficiency and maintainability.</p>
  
  <p>Should I put the .MDB file on the server and place a shortcut to it on each machine?  (There will only be two to three users at a time.)  Or put a copy of the file on each machine?  And if I'm using a 3rd-party ActiveX, does it need to be installed on each machine even if the .MDB is on the server (I assume so, but just checking), or just on the server?</p>