查看表链接表的关系。 [英] View table Relationship of Linked Table.

问题描述

我有一个SQL Server Express版本。 SQL-A

I have a SQL Server Express edition. SQL-A

我在数据库中有几个表。表定义了关系。

I have few tables in a database. Tables have relationships defined.

创建了一个新的MS Access文件，并将SQL Server数据库表作为链接表添加到MS Access。

Created a new MS Access file and added SQL Server Database tables as Linked tables to MS Access.

MS Access能够恢复数据。

MS Access is able to fetch data corrected.

我可以登录到SQL Server并查看关系，但希望通过MS Access获取信息。

I can login to SQL Server and view the relationship but would like to get the information via MS Access.

是否有以何种方式查看MS Access链接表之间的关系？  

Is there any way to view the relationship between linked table from MS Access?  

提前致谢。

问候-Raj

Rajendra Dewani

网站： http://www.dewani.net

Rajendra Dewani
Website : http://www.dewani.net

推荐答案

您好，在后端数据库上创建了关系，因此您只能在SQL Server中查看它们。但是，有人可能会给您一些代码来列出Access中的表关系。祝你好运。

Hi, Relationships are created on the backend database, so you can only view them in SQL Server. However, someone might be able to give you some code to list the table relationships in Access. Good luck.

这篇关于查看表链接表的关系。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！