<div>
see<br />
<a href="https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10157383" rel="ugc">https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10157383</a>&nbsp;<br />
<br />
it helps you a lot<br />
<br />

</div>


see
https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10157383 [https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10157383] 

it helps you a lot



<div>
<div class="content wysiwyg-content">
I would like to connect to an access97 database using DAO. &nbsp;I do not want to use the path. &nbsp;What is the syntax for using the ODBC DSN in the OpenDatabase command?
</div>
</div>


I would like to connect to an access97 database using DAO.  I do not want to use the path.  What is the syntax for using the ODBC DSN in the OpenDatabase command?

DAO - OpenDatabase

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.