SQL表的奇怪问题只在Access中读取 [英] Strange issue with SQL Table read only in Access
问题描述
我有一个数据文件，我使用
升迁向导从Access转换为SQL Server。然后，我使用
ODBC连接将表附加到Access前端。我有一个表是由于某种原因只读。我是
不确定是怎么回事，它在升级和连接方面经历了与其他
表相同的程序。原始表格未被阅读
仅限或隐藏或其他任何内容，它具有完全权限。
我已尝试断开连接并重新连接表格但仍然相同的
的事情。在SQL Server中，权限与所有其他表相同。
我似乎无法弄清楚是什么让这个只读。
我正在使用SQL Server 2005 Express和Access 2003.任何想法都会很高兴。
谢谢！
" Rico" < r c o l l e s s @ h e m m n n w w y y。完成本部分
CAPS>在消息新闻中写道：zA72g.55411
7a.37458@pd7tw1no ...我有一个数据文件，我从Access转换为SQL Server使用
升级向导。然后，我使用ODBC连接将表附加到Access前端。我有一张桌子只是出于某种原因阅读。
我不确定是怎么发生的，它在升级和连接方面经历了与其他表格相同的程序。原始表格不是只读或隐藏或其他任何东西，它具有完全权限。
我已经尝试断开连接并重新连接表格，但仍然是相同的事情。在SQL Server中，权限与所有其他表相同。我似乎无法弄清楚是什么让这个只读。
我正在使用SQL Server 2005 Express和Access 2003.任何想法都会非常感激。
谢谢！
表中是否有主键？链接到SQL Server的表需要
主键才能更新。
表是否具有主键或者唯一索引？
我不使用ODBC，因为我的手是关节炎的，我不能拿凿子
和锤子（用于石碑） ）更多，但我认为MS-SQL
要求表格具有主要或唯一索引，以便
可更新。
I have a data file that I converted from Access to SQL Server using the
upsizing wizard. I then attached the tables to the Access front end using an
ODBC connection. I have one table that is read only for some reason. I''m
not sure how that happened, it went through the same procedures as the other
tables in terms of upsizing and connecting. The original table was not read
only or hidden or anything else, it had full permissions.
I''ve tried disconnecting and reconnecting the table but still the same
thing. In SQL Server, the permissions are the same as all the other tables.
I can''t seem to figure out what''s making this one read only.
I''m using SQL Server 2005 Express and Access 2003. Any ideas would be
greatly appreciated.
Thanks!
"Rico" <r c o l l e n s @ h e m m i n g w a y . c o mREMOVE THIS PART IN
CAPS> wrote in message news:zA72g.55411
7a.37458@pd7tw1no...I have a data file that I converted from Access to SQL Server using the
upsizing wizard. I then attached the tables to the Access front end using
an ODBC connection. I have one table that is read only for some reason.
I''m not sure how that happened, it went through the same procedures as the
other tables in terms of upsizing and connecting. The original table was
not read only or hidden or anything else, it had full permissions.
I''ve tried disconnecting and reconnecting the table but still the same
thing. In SQL Server, the permissions are the same as all the other
tables. I can''t seem to figure out what''s making this one read only.
I''m using SQL Server 2005 Express and Access 2003. Any ideas would be
greatly appreciated.
Thanks!
Does the table have a primary key? Tables linked to SQL Server need a
primary key to be updateable.
Does the table have a primary or unique index?
I don''t use ODBC as I my hands are arthritic and I can''t hold a chisel
and a hammer (for the stone tablets) any more but I think MS-SQL
requires a table to have a primary or unique index in order to be
updateable.
这篇关于SQL表的奇怪问题只在Access中读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
