Member Avatar for situ.pati

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

  • 3 Contributors
  • 2 Replies
  • 209 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by G_Waddell
Member Avatar for Pgmer

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.

Member Avatar for G_Waddell

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.

Edited by G_Waddell
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.