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
Printable View
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
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. :wave: