Access 2.0链接到Sql Server [英] Access 2.0 link to Sql Server
问题描述
我需要将SQL Server 2005数据库中的表附加（链接）到
Access 2.0前端数据库：
在Access 2.0上：单击File \Attach Table ...，选择< SQL Databaseclick
OK
在SQL数据源上但是，对话框中，我看不到SQL
Server。选择!!!
所以''我无法链接！
我希望我的问题很明确。
感谢您的阅读，
Mourad
I need to attach (link) a table in SQL Server 2005 database to an
Access 2.0 front-end database:
On Access 2.0: Click File\Attach Table..., select <SQL Databaseclick
OK
On the "SQL Data Sources" dialog box, however, I cannot see a "SQL
Server" selection!!!
So'' I''m unable to link!
I hope my question is clear.
Thanks for reading,
Mourad
推荐答案
Hello Mourad，
解决问题的最简单方法是升级到更新版本
Access，如Access 2003（Access 2007的工作方式相当多
不同 - 他们（MS）甚至不再称它为mdb。
如果您正在使用当前（或某种当前的）服务器技术
喜欢sql2005然后你应该使用前端也是当前的
（至少在同一世纪 - Access2003或.Net）。
Rich
***通过开发人员指南 http：// www。 developersdex.com ***
Hello Mourad,
The easiest fix for your problem is to upgrade to a more current version
of Access like Access 2003 (the workings of Access 2007 are considerably
different - they (MS) don''t even call it an mdb anymore).
If you are working with current (or somewhat current) server technology
like sql2005 then you should be using a front end that is also current
(at least within the same century - Access2003 or .Net).
Rich
*** Sent via Developersdex http://www.developersdex.com ***
2008年8月18日星期一13:51:19 -0700（PDT），Mourad< mo **** *** *****@gmail.com>
写道：
On Mon, 18 Aug 2008 13:51:19 -0700 (PDT), Mourad <mo************@gmail.com>
wrote:
>我需要在SQL Server中附加（链接）一个表2005数据库到Access 2.0前端数据库：
在Access 2.0上：单击File \Attach Table ...，选择< SQL Databaseclick
OK
在SQL数据源上但是，对话框中我看不到SQL
服务器。选择!!!
所以''我无法联系！
我希望我的问题很清楚。
感谢阅读，
Mourad
>I need to attach (link) a table in SQL Server 2005 database to an
Access 2.0 front-end database:
On Access 2.0: Click File\Attach Table..., select <SQL Databaseclick
OK
On the "SQL Data Sources" dialog box, however, I cannot see a "SQL
Server" selection!!!
So'' I''m unable to link!
I hope my question is clear.
Thanks for reading,
Mourad
2.0！？！
那是*十五岁* ！你开的是1937线吗？
我目前还没有安装它（是的，我还有十或十二个b / b
盘）但试试寻找ODBC连接而不是SQL /服务器。你需要在控制面板中定义一个ODBC连接...管理
工具......数据源。
-
John W. Vinson [MVP]
2.0!?!
That''s *fifteen years old*!!! Do you drive a 1937 Cord?
I don''t currently have it installed (yes, I still have the ten or twelve
diskettes) but try looking for "ODBC Connection" instead of SQL/server. You
will need to define an ODBC Connection in Control Panel... Adminiistrative
Tools... Data Sources.
--
John W. Vinson [MVP]
我在Informix上使用Access 2.0客户端应用程序。 DBA使用了一个
的第三方ODBC驱动程序（我现在忘记了这个名字，但我记得
该公司被另一个公司收购了），效果非常好。另一方面，我希望我拥有1937年的Cord！但是，我不确定是否有任何
公司仍在销售Access 2.0的驱动程序......也不确定微软是否会（可能）仍然有某个地方可以工作使用SQL Server 2005.
我没有尝试过，但我被告知Access 2.0无法在一台机器上运行
内存超过1GB （或者它是2GB）。我仍然安装Access 2.0的唯一一台机器是装有256MB的老式的1999 PII 450。它是b / b
当时是好的，可靠的软件，如果安全不是问题，那么它仍然是问题。我也被告知你的机器是否是大妈妈。有很多
的内存，你需要运行Access 2.0，你可以创建一个内存少了
的虚拟机，这样它就不会崩溃。
< br $>
Larry Linson
Microsoft Office Access MVP
" John W. Vinson" < jvinson@STOP_SPAM.WysardOfInfo.com在留言中写道
news：ri **************************** **** @ 4ax.com ...
I worked on an Access 2.0 client application to Informix. The DBA used a
third-party ODBC Driver (which name I forget at the moment, but I remember
the company was acquired by another) that worked very well. On the other
hand, I _do_ wish I owned a 1937 Cord! But, I''m not sure whether any
company still sells drivers for Access 2.0... nor whether one that Microsoft
would (probably) still have somewhere would work with SQL Server 2005.
I haven''t tried it, but am told that Access 2.0 will not run on a machine
with more than 1GB memory (or was it 2GB). The only machine on which I
still have Access 2.0 installed is a vintage-1999 PII 450 with 256MB. It
was good, solid software in its day, and still is, if security is not an
issue. I have also been told if your machine is a "big mama" with lots of
memory and you need to run Access 2.0, you can create a virtual machine with
less memory so it doesn''t crash.
Larry Linson
Microsoft Office Access MVP
"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.comwrote in message
news:ri********************************@4ax.com...
2008年8月18日星期一13:51:19 -0700（PDT），Mourad
< mo ************ @ gmail.com>
写道：
On Mon, 18 Aug 2008 13:51:19 -0700 (PDT), Mourad
<mo************@gmail.com>
wrote:
> ;>我需要将SQL Server 2005数据库中的表附加（链接）到Access 2.0前端数据库：
在Access 2.0上：单击File \Attach Table .. 。，选择< SQL Databaseclick
OK
在SQL数据源上但是，对话框中我看不到SQL
服务器。选择!!!
所以''我无法联系！
我希望我的问题很清楚。
感谢阅读，
Mourad
>>I need to attach (link) a table in SQL Server 2005 database to an
Access 2.0 front-end database:
On Access 2.0: Click File\Attach Table..., select <SQL Databaseclick
OK
On the "SQL Data Sources" dialog box, however, I cannot see a "SQL
Server" selection!!!
So'' I''m unable to link!
I hope my question is clear.
Thanks for reading,
Mourad
2.0！？！
那是*十五岁* ！你开的是1937线吗？
我目前还没有安装它（是的，我还有十或十二个b / b
盘）但试试寻找ODBC连接而不是SQL /服务器。
你需要在控制面板中定义一个ODBC连接...管理
工具...数据来源。
-
John W. Vinson [MVP]
2.0!?!
That''s *fifteen years old*!!! Do you drive a 1937 Cord?
I don''t currently have it installed (yes, I still have the ten or twelve
diskettes) but try looking for "ODBC Connection" instead of SQL/server.
You
will need to define an ODBC Connection in Control Panel... Adminiistrative
Tools... Data Sources.
--
John W. Vinson [MVP]
这篇关于Access 2.0链接到Sql Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
