Connecting to Database

The attached zip file is the database table that out teacher wants up to connect to. He wants us to name it electronics_inc.mdb.  I am working off another company's server, so I uploaded the file already. The data source is d:hometrynmybest.comdbelectronics_inc.  The provider is Provider=Microsoft.Jet.OLEDB.4.0. My assignment is below. Thank you

• Connect to a Microsoft Access Database (supplied)  
        via a connection string.
• The name of the database is Electronics_Inc.mdb
• Open a Recordset from the Product Table.
• Modify your order form to so that the user can select  
        from a list of products from a combo box.  
• You will populate the combo box (select) from the
        product table. This will replace the text box.
• You will modify each product line (4) on the order    
        form.  
• Once the products are selected, the rest of your
        application should work as it does now. Meaning, the
        user will still enter the price and the weight of the
        product in a text box.

I've included 2 more attachments.  The first one is the original form that he wants us to modify. The second one is the form that is called when the user clicks the submit button, but I'm confused on how to get the database in this equation. If someone could help me out with this one, I would be very grateful.  Thanks

Attached file(s):

electronics_inc.zip  View File

assignment7.txt  View File

databaseconnection.txt  View File