I have created a database in ms access and a form, in which i want to add some records, it is updating correctly, but when i close the form and restart the application and started to add new records the previous records are deleted automatically. please help me in this

Recommended Answers

All 2 Replies

Show your code.. You checked the DB when you close the application? Once saved in Db will not delete automatically Either your deleting in your code or you are not loading it back.

How are you retrieving and storing your data? Dataset? If so are you remembering that the dataset is not connected to the Database once populated? i.e. you can insert/ modify/ Delete records in it's datatables (they're held in memory) but you have to make specific calls to update the Database with the dataset data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.