sql - "No Value Given for one or more required parameter" after making changes to access database -

sql - "No Value Given for one or more required parameter" after making changes to access database -

i working on vb.net project , connecting access database system.oledb connection. code running fine , showing records in datagridview, had create changes in original database, did. after when run programme gives me error, in fact know there nil wrong code, why error of "no value given 1 or more required parameter" sample code below:

public class frmemployees private shared mycon new oledb.oledbconnection private shared con new oledb.oledbconnection private shared empcmd new oledb.oledbcommand private shared employeecmd new oledb.oledbcommand private shared employeeadapter new oledb.oledbdataadapter private shared employeebuilder oledb.oledbcommandbuilder private shared empdata new dataset private shared emptable new datatable dim id1 string private sub frmemployees_load(sender object, e eventargs) handles mybase.load seek emptable.clear() mycon.connectionstring = "provider=microsoft.jet.oledb.4.0;data source=y:\m&g_training.mdb" employeecmd.connection = mycon employeecmd.commandtype = commandtype.text employeecmd.commandtext = "select employeeid, lastname, firstname, middleinitial, active, hiredate employee active = 'y' order employeeid" employeeadapter.selectcommand = employeecmd employeebuilder = new oledb.oledbcommandbuilder(employeeadapter) employeeadapter.fill(emptable) empbindingsource.datasource = emptable empbindingnavigator.bindingsource = empbindingsource empdatagridview.datasource = empbindingsource grab ex exception messagebox.show(ex.message) end seek end sub

i have changed programme according changes have made in database, please help me, close getting project done. give thanks in advance

sql vb.net ms-access-2010 oledb