title: MS Access changing reference path to a no longer existing path
body: <p>When I compile a MS Access 2003 app on Windows 7 SP1 64bit and launch it in Windows 7 SP1 32bit the Microsoft Common Dialog Control 6.0 (SP3) path changes from <code>C:\Windows\SysWOW64\comdlg32.ocx</code> to <code>\\shared\access\comdlg32.ocx</code> which is the shared drive the app launches from for Windows 7 SP1 32bit users.</p>
  
  <p>I need the reference on 32bit machines to be:  <code>C:\Windows\System32\comdlg32.ocx</code></p>
  
  <p>The 32bit machine errorors out on : <code>Dim Cnxn As ADODB.Connection
      Set Cnxn = New ADODB.Connection</code> But when the Common Dialog Control is referenced correctly by downloading the app to the 32bit machine, browsing for the comdlg32 file, adding it as a reference, and recompiling, the app works fine on the 32bit pc.</p>
  
  <p>What does the Common Dialog Control have to do with ADODB?
  I don't think I use the Microsoft Common Dialog Control anywhere. I will do more testing...</p>