如何在Access 2003中使用链接表重命名字段 [英] How to rename field with link table in access 2003

问题描述

大家好！


我有一个程序将数据库组合到SQL Server 2005.我用

DOBC连接到sql.I想要重命名sql database中的字段。我尝试在访问本地表中测试代码。代码没问题，但是在链接表中执行。访问是宣布链接表不支持操作。 （错误3057）。那怎么解决呢？请帮助我!!!

解决方案

Alias90：

你不能重命名链接表。

你有杀死链接，然后直接进入后端或在这种情况下，我相信你可以做一个pass-thru查询将SQL发送到后端重命名表...对不起，我做得还不够使用SQL server 2005然而，确认这个动作，我必须如何处理其他服务器的事情。


要记住的最重要的事情是重命名不会通过关系级联，也不会查询所以你在重命名表时冒了很大的风险，因为这样做可能会破坏你的前端应用程序，最坏的情况可能导致你的整个后端概念崩溃。


无论如何，然后你可以重新链接到重命名的表。

huhu！ （哭）

我们可以改变另一个解决方案吗？''因为我想要改变的字段不是主键。在这种情况下，重命名字段不会在关系中级联。

您可以尝试直接进入后端以重命名该字段。但是，使用现有链接...它可能会破坏前端中的链接。通过重新连接很容易解决。


至于是否是主键......真的没关系。据我所知，重命名不会通过结构级联。你将不得不编辑引用旧字段名称的所有查询，视图等。


因为这比SQL更多地处理SQL Server我正在移动这个线程可以到MS SQL Server论坛，也许有人能够更好地理解这一点。


我也在重新命名线程以反映手头的问题：MS Access 2003前端在SQL Server后端重命名字段

Hi Everybody!

I have a program combine database to SQL server 2005. I used
DOBC to connect to sql.I want to rename the field in sql database.I tried on testing code in local table in access. The code is OK, but do it in link table. The access is announce "Operation not supported on linked tables. (Error 3057) ". So how to solve it? Please help me!!!

解决方案

Alias90:
You can not rename linked tables.
You have to kill the link and then either go into the backend directly or in this case I believe that you can do a pass-thru query to send the SQL to the backend to rename the table... sorry, I don''t do enough with the "SQL server 2005" to confirm that action however, that how I''ve had to handle things with the other servers.

Biggest thing to keep in mind is that the rename will not cascade thru relationships nor in queries so you take a huge risk in renaming a table in that doing so might break your frontend application at best and at worst can cause your entire backend concept to implode.

In any case, you can then relink to the renamed table.

huhu! (crying)
Can we change another solution?''Cause the field which i want to change isn''t the primary key.In this case, renaming field will not cascade throught relationships.

You can try to just go into the backend directly to rename the field. However, with an existing link... it might break the link in the frontend. Easy enough to fix by relinking.

As for being primary key or not... really doesn''t matter. The rename will not, as far as I know, cascade thru the structure. You will have to edit all the queries, views, etc... that refer to the old field name.

As this deals more with the SQL Server than Access I''m moving this thread to the MS SQL Server forum where maybe someone that understands this a little better can help.

I''m also renaming the thread to reflect the question at hand: "MS Access 2003 Front End to rename Field in SQL Server Back End"

这篇关于如何在Access 2003中使用链接表重命名字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！