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

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
Tony GardnerSr. Programmer/AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
Tony GardnerSr. Programmer/AnalystAuthor Commented:
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.
0
Tony GardnerSr. Programmer/AnalystAuthor Commented:
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.

Tony
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.