ADODC Controls

[lathodio]

What exactly is an adodc control, and can you use it to link mdb databases to a simple form for viewing?<br>

 

[culshaja]

The ADO Data Control is basically the same as the original RDO Data Control in the fact that you put it on the form, link it to a database, and then bind controls to it. The major difference is that it uses OLE DB and this means that you can have native connections to certain databases rather than through ODBC. You also have increased functionality. You connect to an Access database using the Jet 4.0 OLE DB provider. <p>James Culshaw<br><a href=mailto:james_culshaw@activedatasolutions.madasafish.com>james_culshaw@activedatasolutions.madasafish.com</a><br><a href= > </a><br>

 

[eranh]

Example of using AdoDc :<br><br>1. in the windows control panel--&gt;Odbc -- &gt; System dsn (Choose<br>&nbsp;&nbsp;&nbsp;&nbsp;Access Driver and Set a system dsn to your mdb file, give&nbsp;&nbsp;the dsn&nbsp;&nbsp;the&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name: &quot;Mydb&quot;<br><br>2. Put a Ado data control on a form, set his properties:<br>&nbsp;&nbsp;&nbsp;&nbsp;datasource/connection string = &quot;dsn=Mydb&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;command = choose &quot;table command&quot; and select the name of a table from the mdb<br><br>3. add&nbsp;&nbsp;a few textboxex and on each one set their properties:<br>&nbsp;&nbsp;&nbsp;&nbsp;datasource = the name of the ado data control in the form<br>&nbsp;&nbsp;&nbsp;&nbsp;datafield = the name of the field from the table you chose from the mdb<br><br>&nbsp;&nbsp;&nbsp;good luck<br><br>&nbsp;&nbsp;&nbsp;eranh