Access Table in VB

[aaron81]

does anyone know how to put an access table on a VB form


i need to put one there so i can display data

thanks

[RhinoBull]

The simplest way to connect to MS Access database is as follows:

- add DataGrid to your form
- add ADODC (ado data control)
- right click on the ADODC and select ADODC Properties
- while in Property Pages select Use Connection String and click Build button
- when new dialog appears select Providers tab and select MS Jet 4.0 and click Next ...
- you should be now on Connection tab so follow simple instruction there
- click OK button
- select RecordSource tab (Property Pages dialog)
- select Command Type from the drop down box and follow rest of instructions.
- you must be done by now so you can click OK button to close Property Pages
- select DatGrid on your form and in the property window set Datasource to ADODC1.

Run your project.

NOTE: this is NOT efficient way at all but is a good starting point. Eventually you will have to learn how to use ADO library with some other unbound controls.

Good luck.