[AccessD] Difference between Access ADP and Access MDB with SQLlink

In order to take full advantage of SQL Server most processing should take
place on the SQL Server. You may need to rewrite the application to use
Stored Procedures etc. However, I have also seen real improvements using
unbound forms - Charlotte????

One of the big advantages of ADPs is they give you access to graphical tools
for creating server objects which can speed up coding while you learn SQL
Servers version of doing things.

A guy at MS actually recommended using ODBC, and pass through queries for a
lot of stuff. Most fo the stuff we do in the office involves ADPs but again
we are movinig almost totally to web based front ends to almost all large
database systems.

Martin


----- Original Message ----- 
From: "Liam Meadows" <liam at energyexhausts.co.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, September 27, 2003 12:12 AM
Subject: RE: [AccessD] Difference between Access ADP and Access MDB with
SQLlink


> I suppose my question should have been.
> Which one is the better ADP or MDB with SQL ODBC ?
>
> Liam
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
> Sent: 26 September 2003 18:29
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Difference between Access ADP and Access MDB with
> SQLlink
>
>
> You might want to check you have indexing on your SQL tables
> If you don't have a copy of EM Enterprise Manger from full version of
> SQL or know your way around osql, try this free replacement.
> http://www.asql.biz/DbaMgr/DownLoad2k.shtm
>
> Liam Meadows wrote:
>
> > I have started to rewrite an application in ADP which has been a bit
> > of a pain but today I had a mess about and created an MDB with a SQL
> > ODBC link to the data and on one particular form which has a filtered
> > list on it the ADP version is about 3 times slower and bringing the
> > list in where as the MDB with ODBC SQL link flies.
> > I'm lead to believe that a normal MDB when accessed across a network
> > will transport all the data to the local machine first before running
> > is this true of SQL link ?
> >
> > Regards
> >
> > Liam
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>