troubleshooting Question

DataMember property <<Relationship_Reference>> cannot be found on the DataSource

Avatar of Tony Gardner
Tony GardnerFlag for United States of America asked on
Visual Basic.NETMicrosoft Access
7 Comments1 Solution126 ViewsLast Modified:
Hello Experts.

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:
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros