来自mssql服务器的ms访问链接表 [英] ms access linked table from mssql server

问题描述

大家好，
我在ms sql中有一个数据库，并且在ms access中有链接表.当前我需要向链接表中添加更多字段.如何向链接表中添加新字段
帮帮我，谢谢.
问候，
Shefeek

Hi all,
I have a database in ms sql and i have linked tables in ms access.Currently i need to add some more fields to the linked table.How can i add new fields to the linked table
Help me,thanks in advance.
Regards,
Shefeek

推荐答案

您将必须在SQL Server中添加字段，然后刷新链接以使新列在ms访问中可用.

You would have to add the fields in SQL Server and then refresh the link for the new columns to be available in ms access.

这篇关于来自mssql服务器的ms访问链接表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！