Create you database in access. Then use the dataform wizard to make you an example on how to connect to it.Start new standard exe project.
In VB's IDE, goto VB's menu Add-Ins>Add In Manager.
Select/highlight VB 6 Data Form Wizard.
In lower right corner where frame has caption of "Load Behavior" put check in box next to Loaded/Unloaded.
Click OK
GoTo Add-Ins>Data Form Wizard.
Follow instruction and when it comes to form type and the options of ADODC, Code, or Class, I would suggest that you run this wizard as many times as needed to select each form type and each option so that you have an example from every possible combination.
Save this project for reference.
Good Luck