[AccessD] A2K3 ADP

Not really, since Microsoft is not going to continue support of 
ADPs.  All those using them will have to re-tool their applications.

I have some massive MDBs that connect only to SLQ Server, using 
ODBC.  I was going to rewrite them to ADPs, but when I heard they 
were not going to be supported, I stopped.  I am rewriting them in 
.Net instead.

And, stored procs work fine using ODBC, just use a pass through 
query.  Normally, I have one without the parameters (_0) that I use 
to build the one with the parameters (_1).  And I simply change the 
SQL statement in code for the _1 query.  If you are worried about the 
connection string, simply replace it through code also.

Robert

At 10:11 AM 11/18/2005, you wrote:
>Date: Fri, 18 Nov 2005 10:54:16 -0500
>From: "William Hindman" <wdhindman at bellsouth.net>
>Subject: Re: [AccessD] A2K3 ADP
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <001901c5ec58$54a7fde0$6101a8c0 at JISREGISTRATION.local>
>Content-Type: text/plain; format=flowed; charset="iso-8859-1";
>         reply-type=original
>
>...just call me Dinosaurus Rex :)
>
>Willam
>
>----- Original Message -----
>From: "Steve Erbach" <erbachs at gmail.com>
>To: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>
>Sent: Friday, November 18, 2005 7:48 AM
>Subject: Re: [AccessD] A2K3 ADP
>
>
> > William,
> >
> > Following on to John's other question about connecting to SQL Server, are
> > you saying that when connecting to SQL Server data sources (for the time
> > being, anyway) you're relying on ODBC and DAO 3.6 in MDB's? Very
> > interesting. Pass-through queries and all?
> >
> > Steve Erbach
> > Neenah, WI
> >
> > On 11/16/05, William Hindman <wdhindman at bellsouth.net> wrote:
> >>
> >> ...I dropped any work with ADPs when MS made it clear they weren't the
> >> future ...had enough learning on my pallet as it was ...not that I was
> >> happy
> >> with the performance I got with an ADP anyway ...I'm pure DAO 3.6 for the
> >> moment and doing just fine :)
> >>
> >> William
> >>
> >> ----- Original Message -----
> >> From: "John Bartow" <john at winhaven.net>
> >> To: "_DBA-Access" <AccessD at databaseadvisors.com>
> >> Sent: Wednesday, November 16, 2005 12:52 PM
> >> Subject: [AccessD] A2K3 ADP
> >>
> >>
> >> > Does anyone have comments on ADPs with A2K3?
> >> >
> >> > IIRC there were some negatives brought up about them here with previous
> >> > versions.
> >> >
> >> > Are you using ADPs for SQLServer data sources or MDBs via DB
> >> connectivity?
> >> >
> >> > TIA
> >> > John B.
> >>
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >