Re: Future of ADP - new article

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Start an Access2007 ADP, which connected to a SQL Server(2000/2005) database. All the server object design tools are accessible via "Create" tab of the ribbon bar: look into "Tables" group and "Others" group.

"ricol" <ricol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:241CA73F-CD8A-4AA4-ACBA-30A2D4E97B23@xxxxxxxxxxxxxxxx
I have been looking for hours of where the design tool for schemas is hidden
in Access 2007 ADP. Where is it and could it be used in conjunction with the
tools delivered in SQL 2005 Management Studio?
--
Rickard Olsson, Sweden
www.ricol.se/ricoleng


"Vadim Rapp" wrote:

regarding the topic of the future of ADP's: here's new article from MS:

http://technet.microsoft.com/en-us/library/cc178973.aspx

Some notable excerpts:

"Office Access 2007 offers two ways to connect to SQL Server data: linking
to SQL Server and Access Data Projects (ADPs). The preferred way to connect
to SQL Server is MDB file format or ACCDB file format. This enables you to
use the full flexibility of local tables and local queries, while leveraging
the full power of SQL Server. In addition, MDB and ACCDB files link to
multiple SQL Servers and a wide variety of other data sources. Office Access
2007 contains many new features available in both MDB and ACCDB file
formats, but only a subset of those features are available in ADPs."

I think it would be interesting to take a look at some real-life MDB linked
"to multiple SQL Servers and a wide variety of other data sources". Since
Microsoft sees Access as "personal productivity application" (follows from
their survey on Access team blog), this MDB is probably created by a
business analyst, someone not from IT. Would be interesting to take a look.
Must be pretty reliable data.

"However, there are some scenarios where a report might be generated
significantly faster in an ADP file. To add these performance improvements
and retain the flexibility of SQL Server, you can build the majority of the
application in an MDB or ACCDB file and have the file load reports from a
referenced ADP file."

Obviously, ADP alone would not "retain the flexibility of SQL Server".

"One advantage that ADP files have over files in MDB or ACCDB format is the
ability to make design changes to SQL Server objects. ADP files include
graphical designers for tables, views, stored procedures, functions, and
database diagrams."

Only one advantage, that is.

regards




.

Relevant Pages

  • Re: ADP vs. MDB?
    ... i dont believe you; sorry. ... ADP are the best platform in the world; and nobody should have to use ... MDB in the real world for *ANYTHING*. ... I'm sorry that you're a SQL wimp and you just can't learn SQL ...
    (microsoft.public.access.adp.sqlserver)
  • New Technoligy with Jet engine (terminal service and MDB)
    ... Our mdb FE is very complex, using hundreds of forms, queries ... and some to specfic).My server is a x64 AMD Opteron, ... and understood why sql is better. ... and multi user support (i have read where jet engine MDB's ...
    (comp.databases.ms-access)
  • Re: Guide for switching to .ADP from .MDB
    ... After struggling with the .adp for 2 days I have determined ... >decided to go with .mdb with linked tables. ... Performance problems with MDB front-ends to MS SQL Server are rarely a result ... generating the tables on the server, then hand-tweak the script before running ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Query Speed ... Access XP vs Access 2000
    ... With adp all SQL processing is done on the server. ...
    (microsoft.public.access.externaldata)
  • Re: Access front end for sql server
    ... How unfamiliar could an ADP environment be? ... Will report design be different? ... square brackets in JET sql? ... more with an ADP than with an MDB, and I can do more with an MDB than ...
    (comp.databases.ms-access)