How to specify SQL Server CE database size while opening connection through ADO using excel vba?
<p>I have a piece of code which pulls all the data from a SQL Server CE database to Excel. This works fine for small databases (less than 250 MB) but when handling large DB (in my case it is 1.24GB), the ADO connection state is not open.</p>

<p>How can we specify the Max Database size=2047 in connecting string? Here is the one which I tried but that didn't work. </p>

<pre><code>stConnection = "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Max Database Size=2047; Data Source= " &amp; Filepath &amp; " ;Persist Security Info=False"
</code></pre>