title: C# Error in accessing an Access Database over LAN
body: <p>Here's my connection string:</p>
  
  <pre><code>sConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" + lstNet.SelectedItem.ToString() + "\SharedDocs\Documents\Debug\App_File\ggbase.mdb;Jet OLEDB:Database Password=g3n3r4l;";
  </code></pre>
  
  <p>lstNet is a listbox that contains all computers found in the network.</p>
  
  <p>I'm assuming something else is wrong with my connection string.</p>
  
  <p>According to Connection Strings website, to access a database over LAN, the following connection string format is used:</p>
  
  <pre><code>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;
  </code></pre>
  
  <p>I'm assuming that shareName is where my Connection String fails. What is a shareName? And what are the shareNames of Windows XP and Windows Vista / 7 if, say, I placed my database in their Shared Documents / Public Files?</p>
  
  <p>I've tried modifying my connection string into the following:</p>
  
  <pre><code>\C$\Users\Public\Documents\Debug\App_File\ggbase.mdb;Jet OLEDB:Database Password=g3n3r4l;";
  </code></pre>
  
  <p>And I still get the following error:</p>
  
  <p>"Format of Initialization string does not conform to specification"</p>
  
  <p>May I have some help on this, please?</p>
  
  <p>EDIT: Tried accessing the database in the Public\Documents section of a Windows Vista PC on my network with the following connection string:</p>
  
  <pre><code>\Public\Documents\Debug\App_File\ggbase.mdb;Jet OLEDB:Database Password=g3n3r4l;";
  </code></pre>
  
  <p>I also tried to access my own (Windows 7 PC) local Public\Documents section using the same connection string, since the serverName can be changed using the program.</p>
  
  <p>Still nothing.</p>