I have a small access database and all I need to do is to show all the data in the database in mu form as a list/table of data. Please Help
All you need is to Open Projects->Components
Check Microsoft ADO data control
Check Microsoft Data Grid Control in the components Window.
Click OK.
See the tool bar with two small Icons.
Drag both Icons on your form.
On ADODC control, right click to Properties.
In properties click Build. Select the database driver you need. If oracle click(OLEDB provider for oracle).
Click Next. Enter Server name, user name, password,. Then Test Connection. If succeeded msg appears, then OK. Again OK. Goto Record Source tab at ADODC properties. Select Table at first combo box. Wait A while and you see list of all the tables under. Now select your table of choice. Click OK.
Now at properties of Datagrid control, at “datasource” assign ADODC1 (this is automatically displayed.)
Run the form and you see the table in the grid.
Thanks.
