预订建议 [英] Book advice
问题描述
Hello All，
我正在调查将Access 2003应用程序迁移到SQL
Server 2005，使用Access ADP作为前端。使用存储过程和未绑定的Access表单也很重要。我没有特别需要有关存储过程或SQL服务器的帮助，更多
如何实现我概述的特定场景
那里有书籍/互联网资源，人们会建议吗？
任何帮助都会非常感激。
TIA。
Hello All,
I''m investigating moving some Access 2003 applications over to SQL
Server 2005, using Access ADP as the front-end. It''s would also be very
important to use stored procedures and unbound Access forms. I don''t
really need help on stored procedures or SQL server specifically, more
how to implement the particular scenario I outlined
Are there any books/internet resources out there that people would
recommend?
Any help would be much appreciated.
TIA.
推荐答案
Mo< 99 ********** @ 99qmul.ac.ukwrote：
Mo <99**********@99qmul.ac.ukwrote:
>我正在调查使用Access ADP作为前端将一些Access 2003应用程序迁移到SQL
Server 2005。使用存储过程和未绑定的Access表单也很重要。
>I''m investigating moving some Access 2003 applications over to SQL
Server 2005, using Access ADP as the front-end. It''s would also be very
important to use stored procedures and unbound Access forms.
为什么未绑定的Access表单如此重要？您也可以在
VB.Net或其他类似的内容中重写应用程序。
此外，在多个版本的Access中，ADP尚未得到增强。我们强烈建议您使用链表来保留MDB。 ADP虽然可以正常工作，但是与MDB相比，
有他们的怪癖和微妙的差异。
使用存储过程和视图当然是好事。 br />
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/
10月20日，8：53 * pm，Tony Toews [MVP] ]" < tto ... @ telusplanet.netwrote：
On Oct 20, 8:53*pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
此外，在多个版本的Access中，ADP尚未得到增强。
Also ADPs haven''t been enhanced in several versions of Access.
TTBOMR Access 2003与Access 2002不同，允许将报告的记录集
设置为ADO记录集。我认为这是一个增强。那个
意味着在最后一个版本的Access中没有增强ADP（仅限）。
除非当然包括MDB中的增强功能，例如
功能区。功能区是mdb（accdb）的增强功能吗？ ADP
有功能区吗？什么，是的，相同的色带？那么accdb功能区是一个
增强功能，而adp功能区是肝切碎的吗？
TTBOMR Access 2003, unlike Access 2002, allowed a report''s recordset
to be set to an ADO recordset. I think this was an enhancement. That
would mean ADPs weren''t enhanced in the last version of Access (only).
Unless of course one included the enhancements that are in MDBs, like
the ribbon. Is the ribbon an enhancement to an mdb (accdb)? Do ADPs
have a ribbon? What, yes, the SAME ribbon? So the accdb ribbon is an
enhancement and the adp ribbon is chopped liver?
> *我们强烈要求
建议您使用链接表保留在MDB中。 *另外，ADP虽然有效，但与MDB相比，
有他们的怪癖和微妙的差异。
>*We would strongly
recommend you stay in the MDB with linked tables. * Also ADPs, while they do work,
have their quirks and subtle differences compared to MDBs.
谁是我们？这个新闻组中ADP最强烈的批评者是那些从未使用它们的人。
Who are "We"? The strongest detractors of ADPs in this newsgroup have
been those who have never used them.
使用存储过程和视图是很好的事情。课程。
Using stored procedures and views are good things of course.
在使用ODBC链接到SQL-Server数据库的MDB中创建和维护存储过程和
视图有多方便？ br />
如果我们随机选择100 mdbs / accdbs链接到SQL Server
数据库，那么有多少人会使用T-的巨大功率br />
SQL？
How convenient is it to create and maintain stored procedures and
views in an MDB linked to an SQL-Server db with ODBC?
If we selected at random a 100 mdbs/accdbs linking to an SQL Server
database via ODBC how many of then would use the enormous power of T-
SQL?
非常感谢您的讨论。
但是，我不是你真的回答了我的要求。
必须有一些材料可以详细讨论这个问题吗？ br />
Thanks very much for the discussion.
However, I don''t either of you really answered my request.
There must be some material out ther which discusses this in detail?
这篇关于预订建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
