It's been a while since I've last posted a question. I had pretty much given up on my VB.NET Windows Form project, but something stirred up inside me, and I'm back on the horse.
Somewhere in the process of making code changes and fixing bugs, I got it in my head that I wanted to change the back-end database structure. This included changing the key to a data table called "Teams" from being Int32 to String. I also needed to change some other tables which reference the Teams key, but strangely that didn't include the ones in the error I'm trying to resolve. I'll admit it right now, my biggest mistake is that I use MS Access to make the changes. Of course now, I'm needing someone to throw me a rope, and help get me out of deep water so I can go back to coding.
I'm pretty sure that changing the table's key datatype was not the problem "per se" but because Access requires you to remove the relationships before making that kind of change. Yes, I put back the relationships, but now whenever I try to fire up the Designer, I get these errors:
- DataMember property "TableTypesLocations" cannot be found on the DataSource.
- DataMember property "TeamsRoster" cannot be found on the DataSource.
- DataMember property "TeamsRoster1" cannot be found on the DataSource.
I've been going through my project trying to repair the damage on my own, but so far have not gotten much success.
Any suggestions on a good place to start would be very much appreciated!
Here are some of the relevant project files, let me know if there are others you need to review: