[AccessD] ACCESS Left Behind

Jim Lawrence accessd at shaw.ca
Sat Jan 24 23:54:25 CST 2015


Arthur:

Don't ever get suckered into pass-through queries...they are slow at best, a security risks and unreliable at worse.

If you are going to follow the external BE route do it right and save a lot of grief.

Jim   

----- Original Message -----
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Thursday, January 22, 2015 1:27:43 PM
Subject: Re: [AccessD] ACCESS Left Behind

Mark,

You say that as if it were a bad thing. I'm not sure why, particularly when
from within Access, you can use Pass-Thru Queries to fire the stored procs.

Arthur

On Thu, Jan 22, 2015 at 3:37 PM, Mark Simms <marksimms at verizon.net> wrote:

> My experience a few years ago: if you used linked tables to SQL Server,
> query retrieval times were 2x that of native SQL queries. Updates and
> Inserts were up to 10x !!!
>
> Conclusion: you must use stored procs for everything....reports, forms,
> etc.
>
> > You know what I find most interesting in this whole transition is that
> > SQL
> > Server Express didn't seem to catch on.
> >
> > Susan H.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list