If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table relationships
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. |
#2
|
|||
|
|||
Table relationships
"dw" wrote in
: 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 |
Thread Tools | |
Display Modes | |
|
|