[AccessD] Access ADP file format

[Ryan W]

Paul,

Can you give me an abbreviated version of how that works? I assume you can’t write back data without custom code because of the stored procedure ?

Sent from my iPhone

> On Mar 26, 2023, at 4:07 PM, Paul Wolstenholme <Paul.W at industrialcontrol.co.nz> wrote:
> 
> 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
>> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com