It is acting like there is a problem with the database connection.
Do you know if the Access database is corrupted or are the tables being used by someone else?
When you close VB, do you close the db connection?
You may need to close and open you dataset inside VB to see the new information.
There is an explict call to access which will force it to complete any pending actions.