Changes not showing in Access Database


I’m very new to visual basic and I am trying to add, remove and edit entries to a MS Access Database. I have a data grid view in Visual Studio where I can see all my entries over multiple runs (saves at the end of the session). I have a 2 part problem:

  1. Every time I enter a new entry into my visual studio, my database table does not get updated.
  2. When I try to remove the selected row followed by save, the entire table gets deleted.

Please see snippet of my code below:

I use add to add new rows to my table and then I use the save button to endEdit and Update my table and use a removeCurrent to remove current selection followed by save

I apologize if this question has been asked previously but I could not find the right solution anywhere and since I am very new to this, having a hard time trying to figure this out.

I am using VS 2017 and MS-Access 2016.

Source: Visual Studio Questions