I have an MS-Access database that was converted to use SQL Tables using the "Microsoft SQL Server Migration Assistant 2008 for Access" (aka SSMA) and created linked tables (so the MS-Access interface still works but is linked to SQL Tables).
我有一个MS-Access数据库,使用“Microsoft SQL Server迁移助手2008 for Access”(又名SSMA)转换为使用SQL表并创建链接表(因此MS-Access接口仍然可以工作但链接到SQL表) 。
Modifying those tables has been no problem (modify in SQL, use the Linked Table Manager in MS-Access, update tables). But I've not added a new table in SQL and I can't find a way to add that table to the set of linked tables.
修改这些表没有问题(在SQL中修改,在MS-Access中使用链接表管理器,更新表)。但我没有在SQL中添加新表,我找不到将该表添加到链表表集的方法。
I've tried the External Data -> ODBC Database, but it wants me to make a FileDSN and since the SSMA tool didn't require that I don't want to have some tables linked one way and other files liked another way (does anyone know how SSMA links the tables?).
我已经尝试了外部数据 - > ODBC数据库,但是它要我制作一个FileDSN,因为SSMA工具不要求我不想让一些表链接到一个方式而其他文件喜欢另一种方式(是的有谁知道SSMA如何链接表?)。
So my underlying question is: Without using DSN how do I add an additional SQL Server table to MS-Access as a linked table?
所以我的基本问题是:如果不使用DSN,如何将其他SQL Server表作为链接表添加到MS-Access?
2 个解决方案
#1
I always create a DSN for development in order to make creating linked tables easy. Then after linking, I run Doug Steele's code to convert them to DSN-less connect strings:
我总是创建一个DSN用于开发,以便轻松创建链接表。然后在链接之后,我运行Doug Steele的代码将它们转换为DSN-less连接字符串:
http://www.accessmvp.com/djsteele/DSNLessLinks.html
Theoretically, his code would tell you enough to figure out how to link DSN-less without using the DSN as a starting point, but I've never found it worth the effort, since it's so easy to create the development DSN and run the conversion once the links are created.
从理论上讲,他的代码会告诉你如何在不使用DSN作为起点的情况下找出如何链接DSN-less,但我从未发现它值得付出努力,因为创建开发DSN并运行转换非常容易创建链接后。
#2
This is a pretty popular question on SQLServerPedia, and read through the answers here:
这是关于SQLServerPedia的一个非常受欢迎的问题,请阅读这里的答案:
#1
I always create a DSN for development in order to make creating linked tables easy. Then after linking, I run Doug Steele's code to convert them to DSN-less connect strings:
我总是创建一个DSN用于开发,以便轻松创建链接表。然后在链接之后,我运行Doug Steele的代码将它们转换为DSN-less连接字符串:
http://www.accessmvp.com/djsteele/DSNLessLinks.html
Theoretically, his code would tell you enough to figure out how to link DSN-less without using the DSN as a starting point, but I've never found it worth the effort, since it's so easy to create the development DSN and run the conversion once the links are created.
从理论上讲,他的代码会告诉你如何在不使用DSN作为起点的情况下找出如何链接DSN-less,但我从未发现它值得付出努力,因为创建开发DSN并运行转换非常容易创建链接后。
#2
This is a pretty popular question on SQLServerPedia, and read through the answers here:
这是关于SQLServerPedia的一个非常受欢迎的问题,请阅读这里的答案: