[AccessD] ACCESS Left Behind

Hi Jim,
On the issue of performance would the stated example, when compared to using
an a native access db,  make a noticeable difference in a small office with
very few users?

John B

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Friday, January 23, 2015 8:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] ACCESS Left Behind


 While that's true to an extent, you just need to understand what's going on
under the hood.

 You can get very acceptable performance just with linked tables, but some
of the features that make Access easy to use will cause you a problem.

 Something as innocent as an IIF() in a query, which many use, and boom,
lousy performance (any Access, VBA, or JET specific expression in a query
forces JET to process the query rather than passing it off to SQL).

Jim.