访问sql server的前端 [英] Access front end for sql server
问题描述
我已经在Access中编程了大约10年。我现在要求
为存储在SQL中的数据创建一个Access前端
服务器。
我的印象是这样做的唯一方法是使用.adp
应用程序，而不是.mdb文件。这是正确的吗？
是否可以将DAO或ADO与.adp对象一起使用？
另外，是否有一本很好的制作手册SQL的访问前端
服务器数据？
Gwindor
2008年6月28日星期六10:52:40 -0400，Gwindor< gw ***** @ verizon.net>
写道：
不，您还可以创建到SQL Server的ODBC连接，并在熟悉的MDB环境中保持
。
看来MSFT正在逐步取消对ADP的支持。
-Tom。
>我已经在Access中编程了大约10年。我现在被要求为存储在SQL
服务器中的数据创建Access前端。
我的印象是，唯一的方法是使用.adp
应用程序，而不是.mdb文件。这是正确的吗？
是否可以将DAO或ADO与.adp对象一起使用？
另外，是否有一本关于SQL的访问前端的好手册
服务器数据？
Gwindor
" Gwindor" < gw ***** @ verizon.netwrote in message
news：3m ************************* ******* @ 4ax.com ...
>我已经在Access中编程了大约10年。我现在要求
为存储在SQL中的数据创建一个Access前端
服务器。
我的印象是这样做的唯一方法是使用.adp
应用程序，而不是.mdb文件。那是对的吗？
不，希望如果您使用ms-access，那么您多年来一直在分割您的
数据库？
>
是否可以将DAO或ADO与.adp对象一起使用？
当你去ADP时，你不能使用DAO，默认情况下它都是ADO。并且，ADP项目
仅适用于sql server。如果您使用链接表，那么您可以使用任何数据库服务器
。
因此，对于现有应用程序，我们倾向于使用链接
表。这些表可以链接到您的后端（mdb），或链接到sql
服务器。当您进行此链接时，大多数（如果不是全部）代码和
应用程序窗口只需像以前一样运行。
这意味着您可以开发应用程序，然后拆分它。确保它
工作，然后将后端升级到sql server，然后将前端
结束链接到那个。
以下是一些应该使用的链接：
http://support.microsoft.com/default...19&Product=acc
ACC2000 ：Access 2000升迁工具白皮书下载
中心
http ：//support.microsoft.com/？id = 241743
ACC2002：Access 2002 Upsizing Tools白皮书可供下载
中心
http ：//support.microsoft.com/？id = 294407
ACC2000：优化客户端/服务器性能（odbc）
http://support.microsoft.com/?id=208858
ACC：升级到Microsoft SQL Server白皮书下载
中心（a95和a97）
http://support.microsoft.com/?id=175619
如何：将Access数据库转换为SQL Server（a97，a2000）
http://support.microsoft.com/?id=237980
ACC：选择数据库工具白皮书可在下载中心获得
Choose.exe文件包含一个名为选择的文档正确的数据库
工具"讨论微软的数据库产品：Microsoft Access，
Microsoft FoxPro，Microsoft SQL Server，Microsoft Visual Basic和Open
数据库连接（ODBC）。使用此文档来确定哪个数据库
工具适合您。
http://support.microsoft.com/?id=128384
ACC：优化附加SQL表上查询的提示
http://support.microsoft.com/?id=99321
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
< a href =mailto：pl ***************** @ msn.com> pl ***************** @ msn .com
Tom van Stiphout< no ************* @ cox.netwrote：
< blockquote class =post_quotes>
>看来MSFT正在逐步取消对ADP的支持。
MSFT肯定没有对过去几个版本的ADP进行任何增强。
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以
阅读整个帖子消息。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
Tony的Microsoft Access博客 - http://msmvps.com/blogs/access/
I have been doing programming in Access for about 10 years. I am now
being asked to make an Access front end for data that is stored in SQL
Server.
My impression is that the only way to do this is to use a .adp
application, rather than an .mdb file. Is that correct?
Is it possible to use DAO or ADO with .adp objects?
Also, is there a good manual on making access front ends for SQL
server data?
Gwindor
On Sat, 28 Jun 2008 10:52:40 -0400, Gwindor <gw*****@verizon.net>
wrote:
No, you can also create an ODBC connection to the SQL Server and stay
within the familiar MDB environment.
It appears MSFT is phasing out support for ADP.
-Tom.
>I have been doing programming in Access for about 10 years. I am now
being asked to make an Access front end for data that is stored in SQL
Server.
My impression is that the only way to do this is to use a .adp
application, rather than an .mdb file. Is that correct?
Is it possible to use DAO or ADO with .adp objects?
Also, is there a good manual on making access front ends for SQL
server data?
Gwindor
"Gwindor" <gw*****@verizon.netwrote in message
news:3m********************************@4ax.com...
>I have been doing programming in Access for about 10 years. I am now
being asked to make an Access front end for data that is stored in SQL
Server.
My impression is that the only way to do this is to use a .adp
application, rather than an .mdb file. Is that correct?No, hopefully, if you been using ms-access, then you been splitting your
databases for years?
>
Is it possible to use DAO or ADO with .adp objects?When you go ADP, you can''t use DAO, it all ADO by default. And, ADP projects
are ONLY for sql server. if you use linked tables, then you can use just
about any database server.
For this reason, for existing applications, we tend to prefer using linked
tables. Those tables can be linked to your back end (mdb), or linked to sql
server. When you do this linking, most, if not all of your code and
application sill simply function as before.
This means that you can develop the application, then split it. make sure it
works, and then upgrade the back end to sql server, and then link the front
end to that.
Here is some links that should be of use:
http://support.microsoft.com/default...19&Product=acc
ACC2000: "Access 2000 Upsizing Tools" White Paper Available in Download
Center
http://support.microsoft.com/?id=241743
ACC2002: "Access 2002 Upsizing Tools" White Paper Available in Download
Center
http://support.microsoft.com/?id=294407
ACC2000: Optimizing for Client/Server Performance (odbc)
http://support.microsoft.com/?id=208858
ACC: "Upsizing to Microsoft SQL Server" White Paper Available in Download
Center (a95, and a97)
http://support.microsoft.com/?id=175619
HOW TO: Convert an Access Database to SQL Server (a97,a2000)
http://support.microsoft.com/?id=237980
ACC: Choosing Database Tools White Paper Available in Download Cente
The Choose.exe file contains a document called "Choosing the Right Database
Tools" that discusses Microsoft''s database products: Microsoft Access,
Microsoft FoxPro, Microsoft SQL Server, Microsoft Visual Basic, and Open
Database Connectivity (ODBC). Use this document to decide which database
tool is right for you.
http://support.microsoft.com/?id=128384
ACC: Tips for Optimizing Queries on Attached SQL Tables
http://support.microsoft.com/?id=99321
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Tom van Stiphout <no*************@cox.netwrote:
>It appears MSFT is phasing out support for ADP.MSFT certainly haven''t made any enhancements to ADPs for the last few versions.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony''s Microsoft Access Blog - http://msmvps.com/blogs/access/
这篇关于访问sql server的前端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
