Excel Data Connection - Unrecognized Database Format
<p>I have a data connection in several Excel documents that share the same source file on a shared network.  If one user opens the <em>source file</em> and another user attempts to refresh the data connection, the query fails and displays an <code>Unrecognized database format</code>.  It will then try to open the source file as a <code>Read-Only</code> copy.</p>

<p>There has to be a way to designate that the source file in this data connection is to be <em>Read Only</em>, and that it shouldn't matter if somebody else has the source file open.</p>

<p>I have tried a whole slew of different options, including a "ReadOnly" statement in the Connection String, adding <code>DISTINCT</code> after the <code>SELECT</code>command, editing in Microsoft Query, etc.  Does anybody know how to force the data connection to retrieve the source file as <em>Read Only</em> and pull in whichever data was last saved even if the source document is open somewhere?</p>

<p>My OBDC Connection String is:</p>

<pre><code>DSN=Excel Files;DBQ="File Path";DefaultDir="Directory Path";DriverId=1046;MaxBufferSize=2048;PageTimeout=5;ReadOnly=1;
</code></pre>