I am using the version of Access shipped with MS 365. I have been using various versions of Access for over 10 years so I'm very comfortable creating a db and creating and altering the structure of a table.
However I have run into a strange problem. I have a database which I have been accessing and altering its data via a VB.Net app. When I try to add a new field to a table I use the Access app Design view. It appears to add the new field correctly. I close Access, reopen it and the new field is present in the table's design view. However, when I try to access the table via a SQL statement in my VB app it fails. When I re-open the database using the Access app the new field has disappeared.
I've never run into a situation, with previous Access versions, where I've been unable to alter a table's structure. Any suggestions would be appreciated.