Best Practices for Managing VB.NET Windows Forms apps with Multiple Dynamic Data Tables

Tony Gardner
Tony Gardner used Ask the Experts™
Hello Again Experts.

I must apologize in advance for my brevity, but I recently injured my hand in the wood shop, and typing is somewhat difficult.

The situation that I am dealing with right now is that I am very frequently experiencing conflict between changes that I make in my Access tables/queries, and keeping my VB.NET Windows Forms app in sync with these changes. For example, if my program is stable with no DB issues, and I decide that I want to add a new field/column to a given table using Access, when I return to my program, it invariably produces errors related to the changes I make.

Today I made a change to an Access Query which is attached to a DataGridView in which I connected a new table to get a related field value. The Query works fine in Access, but now not only does the program fail to compile because of the DGV association, but the Data Source Configuration Wizard shows what before was a View is now a broken Table!

I'm pretty sure that Visual Studio stores a boatload of data pertaining to my database, and that needs to agree with the MDB file, so I just need to know that correct way to make minor changes to my tables and queries. Ultimately what I'm hoping to accomplish is to find a way to have ONE source for my database definitions, and just have a file (or files) store the data.

I realize this is not a lot to go on, but that's all I can offer for the moment.

Many Thanks,
Tony G.Example Error Condition
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Are you asking how you can update your Datasource in Visual Studio? If so, try selecting the datasource, then right click and select 'Update'. Depending on how your Datagridview is setup, it should pick up the other columns.
Tony GardnerSr. Programmer/Analyst


Thanks for jumping in, Scott. I'm pretty much fed up with MS Access (at least in terms of it being my back-end database for VB.NET development) and very much want to get away from it altogether.

I've downloaded a copy of MySQL in hopes that it will work better, so now my main concern is figuring out how to most easily migrate.

The goal is to learn how to do all my database design using code so I'm not dependent on any front-end software, and also to eliminate the huge overhead associated with using Visual Studio to import my tables. It's certainly easier at first, but having experienced countless hours of fighting wars I now wish that I had learned to do it the "hard way" first.
Sr. Programmer/Analyst
I wish to apologize for the way I expressed my frustration in trying to get MS Access and Visual Studio 2015 to cooperate.

At this point, I have not been successful with learning MySQL sufficiently to make the transition away from Access, so I am going to continue working with what I have, and just be more careful when modifying the back-end MDB file.

I will post a new question with a specific scenario, and supporting files so we can explore best practices for this situation.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial