<div>
<br />
&nbsp;When you created the DSN, did you create a file, user, or system DSN?<br />
<br />
&nbsp; Also, are you working on a 64 bit OS? &nbsp; For 64 bit, there are two ODBC managers; one for 64 and one for 32. &nbsp;Access is a 32 bit app, so you must create it with the 32 bit ODBC manager or it won't see it (the 32 bit one is in the WOW64 directory).<br />
<br />
JimD.
</div>



 When you created the DSN, did you create a file, user, or system DSN?

  Also, are you working on a 64 bit OS?   For 64 bit, there are two ODBC managers; one for 64 and one for 32.  Access is a 32 bit app, so you must create it with the 32 bit ODBC manager or it won't see it (the 32 bit one is in the WOW64 directory).

JimD.

<div>
I'm in a 64 bit, Windows 7 and Access 2010. &nbsp;I was in control panel to make DSN, got my admin to log in, created it, tested connection and rebooted. &nbsp;Now I'm in Access 2010 pressed Import &amp;&nbsp;Link ODBC Database and when I type the DNS name but I don't know what folder to link to.
</div>


I'm in a 64 bit, Windows 7 and Access 2010.  I was in control panel to make DSN, got my admin to log in, created it, tested connection and rebooted.  Now I'm in Access 2010 pressed Import & Link ODBC Database and when I type the DNS name but I don't know what folder to link to.

Region-Capture.jpg

<div>
Thank you, very helpful as always. &nbsp;Fixed it.
</div>


Thank you, very helpful as always.  Fixed it.

<div>
<div class="content wysiwyg-content">
I went through the control panel and made a DNS connection (tested it and it worked). &nbsp;I'm now in Access 2010 front-end, trying to use the wizard to import &amp;&nbsp;link tables to a SQL Server. &nbsp;I don't see the DNS I made anywhere. &nbsp;Someone have a good step-by-step on how to do this? It's been awhile.
</div>
</div>


I went through the control panel and made a DNS connection (tested it and it worked).  I'm now in Access 2010 front-end, trying to use the wizard to import & link tables to a SQL Server.  I don't see the DNS I made anywhere.  Someone have a good step-by-step on how to do this? It's been awhile.

Finding DNS

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.