Table relationships

[dw]

Hello, all. We have an Access db that we use as a front-end to a SQL Server
db, with the SQL Server tables linked in via ODBC. Is there any way to
automatically pull in the table relationships (diagrams) without having to
recreate them in Access? Thank you.

 

[Tim Ferguson]

SQL Server tables linked in via ODBC. Is there any way to
automatically pull in the table relationships (diagrams)

If you use an ADP, then you get to see all the database objects in the
database window, including the db diagrams, triggers, etc.

without having to recreate them in Access?

Don't understand this. You can't create a relationship in Access if the
tables are in SQL Server. Or are you talking about downsizing the whole
thing into a mdb?

B Wishes


Tim F