Relationships List ???

[tmort]

I have a commercial database that was in Access and recently has been upgraded to SQL Server. I also have another linked database that was previously linked to the Access database to do some things that didn't come with the commercial db.

I now want to create a linked db to the SQL server version. I can link fine, but, I have to set up the relationships in Access. There are about 40 or 50 tables and the relationship diagram is very cluttered in the original database. The new db uses similar table names. Is there a way in access to get a list of all the linked tables and there relationships like in the edit relationships window?

If there is it will make it much easier to set up the relationships.

Thanks in advance

 

[The_Doc_Man]

There is a system table called MSysRelationships (or something similar.) You can build a query from it on which you can base reports. It is rather complex, though. I would have to research the exact format of that table. I reverse-engineered it once. I'll say this. It is ugly but manageable with a couple of JOINS to appropriate tables.

You might have better luck by starting with the System Documenter to report on your system objects and then just check Relationships. (Unless the version of Ac you are using doesn't do that any more.)