[AccessD] Worth Upgrading for?

Mark Simms marksimms at verizon.net
Mon Jul 27 20:15:33 CDT 2009


> Dynamically constructed SQL statements should be
> cause for the death penalty unless their coders can prove
> there is no other way to achieve the desired result.

Still, it's incredible to see how much of this "SQL string coding"
continually occurs....
Just look at the plethora of "SQL string" posts in Access Monster and Utter
Access websites.

Of course, much of the problem is in the limited nature of parameters in
Access Queries.
Had they been "enpowered" much like SQL Server stored procedure parameters,
all of this "string coding" would never have occurred in the first place.

Naturally, one must wonder if MSFT had done this intentionally...i.e.
"weakened" Access to sell more SQL Server.






More information about the AccessD mailing list