BenSCooper
Programmer
Dear All,
I've taken over a long established Access database with approx 400 tables. All of these tables (I think) have primary\foreign keys columns defined, but for whatever reason the actual relationships between tables were never created. I'm now in a situation where nobody at the company knows exactly how the tables link together without looking at queries\code to figure it out.
I want to actually define these relationships correctly, but first need to figure out how the tables link together. I could do this through a tedious process of analysing the existing db queries to figure it out, but it would be a great help if anyone knew of software that would do this automatically. Probably a long shot I know, but it will save me weeks if there is a product out there to do this.
Thanks in advance
Ben Cooper
I've taken over a long established Access database with approx 400 tables. All of these tables (I think) have primary\foreign keys columns defined, but for whatever reason the actual relationships between tables were never created. I'm now in a situation where nobody at the company knows exactly how the tables link together without looking at queries\code to figure it out.
I want to actually define these relationships correctly, but first need to figure out how the tables link together. I could do this through a tedious process of analysing the existing db queries to figure it out, but it would be a great help if anyone knew of software that would do this automatically. Probably a long shot I know, but it will save me weeks if there is a product out there to do this.
Thanks in advance
Ben Cooper