SQL Server 2005的补丁？ [英] Patch for SQL Server 2005?
问题描述
我正在为SQL Server 2005开发Access前端。
我使用的Access版本是2003，我发现它不能
更新
SQL Server中通过VBA和SQL的任何表格。
我被困了很长一段时间，直到我在其中一个上看到一条消息/>
会话
说这个版本的Access只能更新SQL Server 2000
及更早版本。
有谁知道这个问题的补丁？如果是的话，我在哪里可以找到
呢？
谢谢，
气泡
2007年4月25日18:05:56 -0700，起泡< bu ********* @ hotmail.com>
写道：
这是不正确的。只要你有一个ODBC驱动程序（SQL Native
客户端），你应该可以很好地连接到SQL2005。
创建一个访问数据项目（ADP） A2003，连接到一个
SQL2005数据库也可以。
-Tom。
>我正在为SQL Server 2005开发Access前端。
我使用的Access版本是2003，我发现它无法在SQL中更新任何表服务器通过VBA和SQL。
我被困了很长一段时间，直到我在其中一个会话上看到一条消息说明此版本的Access只能更新SQL Server 2000
和之前的版本。
有谁知道这个问题的补丁？如果是的话，我在哪里可以找到它？
谢谢，
气泡
4月26日，12：10 pm，Tom van Stiphout< no.spam.tom7 ... @ cox.netwrote：
>
那不对。只要你有一个ODBC驱动程序（SQL Native
客户端），你应该可以很好地连接到SQL2005。
创建一个访问数据项目（ADP） A2003，连接到
SQL2005数据库也可以。
-Tom。
由于以下原因，我不想使用Access项目：
虽然我可以将数据库窗口隐藏为以及所有数据库
对象，
并使用启动表格，没有万无一失的方式让某人使用
Access
显示对象的特殊键。删除Access
项目中的表格确实
删除SQL Server表格。
我访问数据库，仅删除操作删除指向
表的链接。
连接到SQL Server没问题。只是Access 2003
没有
泡泡
bubbles写道：
4月26日下午12:10，Tom van Stiphout< no。 spam.tom7 ... @ cox.netwrote：
这是不正确的。只要你有一个ODBC驱动程序（SQL Native
客户端），你应该可以很好地连接到SQL2005。
创建一个访问数据项目（ADP） A2003，连接到
SQL2005数据库也可以。
-Tom。
由于以下原因，我不想使用Access项目：
虽然我可以将数据库窗口隐藏为以及所有数据库
对象，
并使用启动表格，没有万无一失的方式让某人使用
Access
显示对象的特殊键。删除Access
项目中的表格确实
删除SQL Server表格。
我访问数据库，仅删除操作删除指向
表的链接。
连接到SQL Server没问题。它只是Access 2003
不允许我更新SQL Server 2005中的表格。
Bubbles
你还没有明确说明你的意思。访问
2003无法阻止您更新SQL Server 2005中的DATA。您是否在谈论更新数据或表结构的
？
我对SQL Server 2005表使用Access 97,2000,2002和2003，并且看不到它们之间的任何
差异。
-
Rick Brandt，Microsoft Access MVP
电子邮件（视情况而定）至...
在Hunter dot的RBrandt com
I am developing an Access frontend for SQL Server 2005.
The version of Access I am using is 2003, and I find that it cannot
update
any table in SQL Server through VBA and SQL.
I was puzzled for quite a while, until I saw a message on one of the
sessions
stating that this version of Access can only update SQL Server 2000
and earlier.
Does anyone know of a patch to this problem? If so, where can I find
it?
Thanks,
Bubbles
On 25 Apr 2007 18:05:56 -0700, bubbles <bu*********@hotmail.com>
wrote:
That''s not correct. As long as you have an ODBC driver (SQL Native
Client), you should be able to connect to SQL2005 just fine.
Creating an Access Data Project (ADP) in A2003, connecting to a
SQL2005 database works as well.
-Tom.
>I am developing an Access frontend for SQL Server 2005.
The version of Access I am using is 2003, and I find that it cannot
update
any table in SQL Server through VBA and SQL.
I was puzzled for quite a while, until I saw a message on one of the
sessions
stating that this version of Access can only update SQL Server 2000
and earlier.
Does anyone know of a patch to this problem? If so, where can I find
it?
Thanks,
Bubbles
On Apr 26, 12:10 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:>
That''s not correct. As long as you have an ODBC driver (SQL Native
Client), you should be able to connect to SQL2005 just fine.
Creating an Access Data Project (ADP) in A2003, connecting to a
SQL2005 database works as well.
-Tom.I do not want to use an Access project for the following reason:
although I could hide the database window as well as all the database
objects,
and use a startup form, there is no foolproof way for someone to use
the Access
special keys to reveal the objects. Deleting a table in an Access
project really
deletes the SQL Server table.
I Access database, the delete action merely deletes the link to the
table(s).
Connection to the SQL Server is no problem. Its just that Access 2003
does not
allow me to update tables in SQL Server 2005.
Bubbles
bubbles wrote:On Apr 26, 12:10 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
That''s not correct. As long as you have an ODBC driver (SQL Native
Client), you should be able to connect to SQL2005 just fine.
Creating an Access Data Project (ADP) in A2003, connecting to a
SQL2005 database works as well.
-Tom.
I do not want to use an Access project for the following reason:
although I could hide the database window as well as all the database
objects,
and use a startup form, there is no foolproof way for someone to use
the Access
special keys to reveal the objects. Deleting a table in an Access
project really
deletes the SQL Server table.
I Access database, the delete action merely deletes the link to the
table(s).
Connection to the SQL Server is no problem. Its just that Access 2003
does not
allow me to update tables in SQL Server 2005.
BubblesYou''re still not clearly stating what you mean. There is nothing about Access
2003 that prevents you from updating DATA in SQL Server 2005. Are you talking
about updating data or the structure of the tables?
I use Access 97, 2000, 2002, and 2003 against SQL Server 2005 tables and see no
difference whatsoever between any of them.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
这篇关于SQL Server 2005的补丁？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
