ttention Data Base Gurus VB 6.0 Enterprise

[lathodio]

I am trying to query a ACCESS 97 Data Base, with an ADO data control.&nbsp;&nbsp;How do I write code to query information from the mdb. to a DataGrid?<br><br><A HREF="mailto:christopher.seidel@mhn.com">christopher.seidel@mhn.com</A>

 

[DougP]

Use the Data Form Wizard and let it create everything for you.<br>Click the Add-Ins menu<br>Then Add-In Manager<br>Then find VB 6 Data Form Wizard in the list.<br>Highlight it.<br>Then in the &quot;Load behavior&quot; options click the top two.<br>Then click OK<br>Now click the &quot;Add-Ins&quot; menu again<br>and you will see a new option at the bottom called &quot;Data Form Wizard&quot;<br>Click it and follow the prompts it will let you connect to an Access database.<br>

 

[Amiel]

<br>Let me know how this works for you. For the ADO control <br>call the following:<br><br>adoctl.Database = &quot;the_path_to_the_database&quot;<br>adoctl.rowsource =&quot;The_sqlString_orTable_orQuery&quot;<br>aodctl.requery<br><br>ctrlLinkedToADOControl_LikeADataGridforInstance.refresh<br><br>Let me know if this fixes the problem.<br><br><br><br><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>