Re: A2007 ADPs

It also addresses the need not to have to manually or programmatically link
every single table/view/SP/function that you need. You simply open an ADP
and they're all there. Accomplishing a similar feat in MDB or ACCDB is a
somewhat lengthier and more laborious process.

MS can recommend MDB or ACCDB all they want, but at the moment, ADP is
serving my needs far better.



Rob

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:eOHHuAUrHHA.2152@xxxxxxxxxxxxxxxxxxxxxxx
The only objective of ADP was to have the capability to directly bind a
passthrough query to a form and have it read/write instead of read only,
as it is actually the case with MDB.

With MDB against a sql-server, you have to use a passthrough query when
your design become too complicated or to slow but these queries are
read-only and cannot be binded directly to a form/report. ADP was
developed to correct this deficiency but beside this point, they have done
absolutely nothing beyond that. For example, it's impossible to
manipulate your insertings, updatings and deletings using stored
procedures or to control the refreshing of the current record with
anything but a primary key. I won't pass any comment on all the other
limitations.

From the point of view of a programmer working against a SQL-Server, ADP
is incredibly limited and offers nothing more than the possibility of
directly reading the result of a SP into a bound form; nothing else. In
comparaison to other database interface tools, MDB and ADP are more like
twins than anything else.

(Of course, I talking here about the use of bound forms and not about the
direct manipulation of ADO objects with VBA code; because you can do the
later as easily with MDB than with ADP or with any other VBScript
compatible language like ASP.).

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns994D92A168426f99a49ed1d0c49c5bbb2@xxxxxxxxxxxx
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
please)> wrote in news:#Bc78dLrHHA.4624@xxxxxxxxxxxxxxxxxxxx:

ADP has been cancelled because it offers no real advantage over
MDB file but this conclusion is not based on performance but on
functionality. The capabilities of ADP are so closely related to
MDB that if you cannot do it with MDB, chances are high that you
cannot do it with ADP either.

I always felt that one of the chief motivations for creating the ADP
was the unreasonable prejudice among many outside the Access
community against Jet, either as data store or as data interface to
server back ends.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/




.

Relevant Pages

  • Re: From .mdb to .adp database
    ... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A2007 ADPs
    ... to an ADP from an MDB when A2000 ... Frankly whilst I know some Access developers don't like ADP's, ... complexity of the few reports. ... Please convince me that Linked Tables work as well as an ADP. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A2007 ADPs
    ... queries with an MDB and these are ideal for complex queries and reports ... I admit I had forgotten about this feature, not having done much MDB work ... On many occasions, it's with reports ... Please convince me that Linked Tables work as well as an ADP. ...
    (microsoft.public.access.adp.sqlserver)
Loading