<div>
ADO or DAO?<br />
<br />
For ADO:<br />
<br />
Dim myConn As ADODB.Connection<br />
Set myConn = New ADODB.Connection<br />
myConn.ConnectionString = &quot;Provider=Microsoft.Jet.OL<wbr />EDB.4.0;Da<wbr />ta Source=c:\myfolder\mydatab<wbr />ase.mdb;Pe<wbr />rsist Security Info=False;&quot;<br />
myConn.Open
</div>


ADO or DAO?

For ADO:

Dim myConn As ADODB.Connection
Set myConn = New ADODB.Connection
myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myfolder\mydatabase.mdb;Persist Security Info=False;"
myConn.Open

<div>
One more question befor i give you the points.<br />
<br />
How do you get a list of the tables in the access database
</div>


One more question befor i give you the points.

How do you get a list of the tables in the access database

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a access data base .I need to create a dsnless connection to it.Can anybody help
</div>
</div>


Hi

I have a access data base .I need to create a dsnless connection to it.Can anybody help

DSN Less Connection to a access database

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.