Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

link table as "table" instead of "view" possible in adp?

Status
Not open for further replies.
trito

trito

MIS
Jan 31, 2003
12
US
Hi,

Is it possible to create a link table to an external data source as a "table"? Reason is that I upsized a mdb db with many link tables and I want to build a relationship diagram in adp similar to it.

Thanks in advance,

t.t.
 
Sort by date Sort by votes
That is done on the SQL Server side. Enterprise Manager has a diagramer which can be generated from the existing relationships or used to build the relationships.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
394
breezett93
breezett93
batteam
  • Locked
  • Question
Importing Excel data to SQL table using MSAccess .adp
Replies
3
Views
361
lameid
lameid
batteam
  • Locked
  • Question
Need help with .adp report recordsource
Replies
1
Views
192
genomon
genomon
batteam
  • Locked
  • Question
MS Access 2007 .adp use with SQL 2012
Replies
1
Views
209
lameid
lameid
toptech
  • Locked
  • Question
ADP View in MSaccess not sorting properly
Replies
0
Views
178
toptech
toptech

Part and Inventory Search

Sponsor

Back
Top