<div>
use DSN less connection<br />
<br />
see this links<br />
<a href="http://www.accessmvp.com/djsteele/DSNLessLinks.html" rel="ugc">http://www.accessmvp.com/djsteele/DSNLessLinks.html</a><br />
<a href="http://www.connectionstrings.com/" rel="ugc">http://www.connectionstrings.com/</a>
</div>


use DSN less connection

see this links
http://www.accessmvp.com/djsteele/DSNLessLinks.html [http://www.accessmvp.com/djsteele/DSNLessLinks.html]
http://www.connectionstrings.com/ [http://www.connectionstrings.com/]

<div>
I thought a few lines of code I do in startup, the link goes into various of procedures.
</div>


I thought a few lines of code I do in startup, the link goes into various of procedures.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
When I connect an Access UI to a SQL DB, I usually first create a DSN on each workstation through Control Panel, then connecting Access to the DSN?<br />
<br />
Is it possible not to use a DSN, but maybe store all credentials on a local Access table, like server IP, Database, User &amp;&nbsp;Password? &nbsp;<br />
<br />
If this is possible, then how, and will I be able to see the SQL tables, their contents, and bind to them as I normally would in Access?<br />
<br />
Thank you.
</div>
</div>


Hi Experts,

When I connect an Access UI to a SQL DB, I usually first create a DSN on each workstation through Control Panel, then connecting Access to the DSN?

Is it possible not to use a DSN, but maybe store all credentials on a local Access table, like server IP, Database, User & Password?  

If this is possible, then how, and will I be able to see the SQL tables, their contents, and bind to them as I normally would in Access?

Thank you.

Connect Access UI to SQL DB

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.