Table relationships

  • Thread starter Thread starter dw
  • Start date Start date
D

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.
 
SQL Server tables linked in via ODBC. Is there any way to
automatically pull in the table relationships (diagrams)
Click to expand...

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?
Click to expand...

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
 
Back
Top