title: Why does Crystal Report Viewer always asks for login details to Access database on WePOS operating system?
body: <p>I wrote a report using Crystal Reports XI linked to an Access database here C:\MyData.mdb.</p>
  
  <p>The report has one field (simplified for this example) and no sub-reports.</p>
  
  <p>I have used the Forms and WPF Cyrtsal Report Viewer using C# .NET 4.</p>
  
  <p><strong>The report views successfully on my development PC running Windows XP, and on other "tills", also running Windows XP.</strong></p>
  
  <p><strong>However, on a till running WePOS (a sort of cut down Windows XP) the report "always" shows a dialog box asking for login details i.e. Username &amp; Password.</strong></p>
  
  <p>This dialog box also shows the correct path to C:\MyData.mdb.</p>
  
  <p>I have spent many days on this, testing in every way possible (I'm sure everyone remembers times like these!).</p>
  
  <p>I use this code to ensure the database is correctly linked to:</p>
  
  <pre><code>TableLogOnInfo logonInfo;
  
  foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables)
  {
      logonInfo = table.LogOnInfo;
      logonInfo.ConnectionInfo.ServerName = string.Empty;
      logonInfo.ConnectionInfo.DatabaseName = "C:\MyData.mdb";
      logonInfo.ConnectionInfo.UserID = string.Empty;
      logonInfo.ConnectionInfo.Password = string.Empty;
      table.ApplyLogOnInfo(logonInfo);
  }
  </code></pre>
  
  <p>... and it works on every PC with Windows XP, except the one with WePOS.</p>
  
  <p>I've also played with:</p>
  
  <pre><code>report.SetDatabaseLogon(string.Empty, string.Empty, "C:\MyData.mdb", string.Empty);
  </code></pre>
  
  <p>... but It makes no difference.</p>
  
  <ol>
  <li>There is no username or password on the Access database</li>
  <li>All the PC's used have the releveant software installed (runtimes, etc.)</li>
  <li>All the PC's were tested using the Adminstrator account (and file permissions were double checked)</li>
  <li>I've tried ticking the Integrated Security tick box, with no luck</li>
  <li>I set logonInfo.ConnectionInfo.DatabaseName = string.Empty;</li>
  <li>I set logonInfo.ConnectionInfo.ServerName = "C:\MyData.mdb";</li>
  <li>I have tried NOT using any of the above code, instead just made sure the database was in the same place on all PC's, with no luck</li>
  <li>It is an Access 2003 database file</li>
  </ol>
  
  <p>I can only conclude WePOS is so "cut down" that Crystal is silently failing to pass authentication... please help!</p>