Click to See Complete Forum and Search --> : VB Database Entry


teknophile
March 29th, 2001, 06:43 PM
How can I use a File>Open command to open an *.mdb file and bind it to a FlexGrid or a Datagrid for viewing and editing recordsets???

Thanks

TeknoPhile

vchapran
March 29th, 2001, 07:42 PM
Open is used for different purposes. *.mdb file you can use with VB by creating Connection and Recordset objects. The easiest way to do that is:
1. Click on Add-Ins Menu and check if there is VB 6 Data Form Wizard.
2 If you see it, click and run that wizard - everything will be created for you, and then you analize it and learn how to work with such a stuff.
3. If you do not see that wizard, when you clickrd on Add-Ins, then click on Add-In Manager Menu, highlight VB6 DataForm Wizard and check the appropriate check box or boxes in Load Behaviour frame.
4 Run Wizard by clicking on Add-Ins, VB 6 Data Form Wizard.
5. The best way - before to do 1 through 4 steps, it's good idea to read some book about VB and Database.

HTP
Vlad