Re: Access with SQL [ADP?]

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dp (nobody_at_mrspam.com)
Date: 03/09/04 

Date: Tue, 09 Mar 2004 19:03:17 GMT

I would have thought an Access ADP would be the trick for what this many has
asked for.

The fact that nobody in this thread has even mentioned these ADPs is
somewhat troubling to me. Is this dead end stuff? When I first read about
ADP's, I thought, "Hey! I can leverage my existing knowledge of how to get
Access to get up and dance, and take advantage of the speed of SQL at the
same time" In the months (well year now) that I've been wanting to move to
this approach, I have heard less and less about ADPs.

Anyone have any input on ADPs, and why they might not be a good solution for
a client-serverh app like this?

-BrianDP

"James Goodman" <j a m e s@norton-associates.co.u k> wrote in message
news:c08ddq$48t$1@titan.btinternet.com...
> Is Access forming a front-end db for a SQL DB?
> Would it not be possible to utilise some kind of web site (ASP) or
similar.
> It will run much faster over a WAN.
>
> Or are you 'replicating' the SQL Server db to an AccessDB?
> You dont need MSDE to connect to a SQL Server DB. MSDE is the 'desktop'
> version of SQL Server.
>
>
>
>
> --
> Cheers,
>
> James Goodman MCSE, MCDBA
> http://www.angelfire.com/sports/f1pictures
>
>

Relevant Pages

  • Re: Access awake after 7 years?
    ... your assessment that ADPs were a bad idea. ... servers, and even ADO might have been a very good idea, but ADPs were not the ... Because better SQL Server ... like JET saved queries, stored procedure results should be editable! ...
    (comp.databases.ms-access)
  • Re: Access with SQL [ADP?]
    ... The fact that nobody in this thread has even mentioned these ADPs is ... > Or are you 'replicating' the SQL Server db to an AccessDB? ... > You dont need MSDE to connect to a SQL Server DB. ...
    (microsoft.public.sqlserver.programming)
  • Re: ADP Vs. ODBC
    ... which ADPs made much harder. ... SQL Server, I found that ADPs were far and away better than the ... Going from DAO to ADO (my first ... recordset with a WHERE clause), and doesn't work except with Jet ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access with SQL [ADP?]
    ... The fact that nobody in this thread has even mentioned these ADPs is ... > Or are you 'replicating' the SQL Server db to an AccessDB? ... > You dont need MSDE to connect to a SQL Server DB. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access awake after 7 years?
    ... I'm not sure I understand what the "idea" of ADPs was supposed to ... I don't see why MDBs couldn't have had features added to interface ... better with SQL Server, rather than throwing that out and starting ... Server front end solution) on the capabilities of ADO, ...
    (comp.databases.ms-access)