[AccessD] Access ADP file format

[Paul Wolstenholme]

Stuart,

Thanks for that reference.  The bit I like is:
"But you can do almost all the things that were essential to ADPs with VBA
code. E.g. you can still bind a form to an *ADODB.Recordset* created from
an SQL-Server stored procedure via an OleDb-Connection."
I'm thankful to David Emerson for introducing me to that possibility,
helping me to master the technique and for introducing me to this group.
Yes there is more code involved but form loading is so much faster (70 x in
my experience when packets travel 5000km between the front end and back
end ).

Paul Wolstenholme


On Sat, 25 Mar 2023 at 01:51, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> On 24 Mar 2023 at 7:34, Arthur Fuller wrote:
>
> > I digress. Why did the Access team abandon the ADP file format?
> >
>  A clue here:
> https://codekabinett.com/rdumps.php?Lang=2&targetDoc=access-adp-history
>
> Finally, with Access 2013, Microsoft discontinued ADPs and removed support
> for
> them from Access.
> I do not have any inside information on the reasoning and the process
> behind this
> decision. From my outside point of view, I guess the rationale was a
> combination of
> three things.
> *   The adoption of ADPs was not as strong as Microsoft had hoped. Mainly
> due
>     to the flaws and problems outlined above.
> *   The pressure of keeping up with the pretty fast SQL-Server development
> was
>     probably pretty intense for the Access-Team.
> *   The OleDb technology was deprecated and support for it was to be
>     discontinued. This would have removed the very basis ADPs were built
> on.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>