MS Access & VB.Net Connection String in Settings Using User Profile
<p>Hello I Have Made an Application with vb.net and ms access The Connection String in My.Settings is As Shown:</p>

<pre><code>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Ammar\AppData\Local\Empolyee Attendance\Data.mdb;Jet OLEDB:Database Password=ammar87
</code></pre>

<p>So as I have to install this application in many computers, I have tried to make my connection string as shown:</p>

<pre><code>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\%UserProfile%\AppData\Local\Empolyee Attendance\Data.mdb;Jet OLEDB:Database Password=ammar87
</code></pre>

<p>But It Did not work so how can I make the userprofile location in my connection string so that It can varies from computer to an other computer</p>

<p>Best Regards.</p>