if you are useng vb as fornt end and acess 97 as back end u should try to handle constraints such as prinery key, enrorse data intigrity at the front end because giving constraints at the back end cuts the flexibility of using vb . u should try to enforce data entigrity at the vb ebd as much as possible

u can open a recordset (rs.Open ("Ration_card_mast"), con, 1, 2)
all the data in the table is retreaved in the recordset i.e. "rs" then u can one by one trasnsfer it into a array