Dear Frined my simple update statement is not working on my database software with .mdb
CompanyDa.Update(CompanyDs, "DisplaycenterData")
it works but only in cache, when i restart my application the record is not updated.
i solved my problem with some informal steps. i m attaching vb projects zip file, plz open coding for update button and Help me with simple coding.
yes one important thing i need help and suggestion for is that in that project <Company> and <Book Entry> forms are working nice, but with <purchase5.vb> form i m facing problems, specially i cant update new added data/record, it returns error <Syntax error in INSERT INTO statement.> enven i follwed very same coding patterns and formate as i used in other forms in this project, i tried again and again but faild to solve the problem, i also changed table name and fields in database table but it still not working, and <update> coding of other forms is working nice and <purchase5.vb>'s update coding is not working.
(update coding for company and book entry form is working and it is not working with purchase5 form, plz help to solve the problem)
plz help me with simple coding and removing above mentioned error.
to move between all three forms plz click related button at bottom of each form.