snipt

Ctrl+h for KB shortcuts

VB.net

VB6: Connect via ADO to Access 2007 database

1
2
3
4
'Needs Microsoft ActiveX Data Objects Library

ConnectionString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;" & _
  "Data Source=" & FileName & ";"
https://snipt.net/embed/2a8a6722bd207ee8060462d8ff0797ca/
https://snipt.net/raw/2a8a6722bd207ee8060462d8ff0797ca/
2a8a6722bd207ee8060462d8ff0797ca
vb.net
VB.net
4
2016-09-29T22:40:56
True
False
False
/api/public/snipt/12138/
vb6-connect-via-ado-to-access-2007-database
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="c">&#39;Needs Microsoft ActiveX Data Objects Library</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="n">ConnectionString</span> <span class="o">=</span> <span class="s">&quot;PROVIDER=Microsoft.ACE.OLEDB.12.0;&quot;</span> <span class="o">&amp;</span> _ </span><span id="L-4"><a name="L-4"></a> <span class="s">&quot;Data Source=&quot;</span> <span class="o">&amp;</span> <span class="n">FileName</span> <span class="o">&amp;</span> <span class="s">&quot;;&quot;</span> </span></pre></div> </td></tr></table>
access, database, vb6
Copyrighted, illegal, or inappropriate content? Email support@snipt.net.