[AccessD] Access Queries

Ok. Most professional developers I know write inline SQL like breathing
air. Not to mention dynamically.
On Feb 20, 2012 11:26 AM, "Mark Simms" <marksimms at verizon.net> wrote:

> I'm not a "string SQL" person. I've always thought this was the worst of
> the
> worst features of Access.
> I create canned queries and then have a procedure for string replacement
> ...
> Trying to keep everything consolidated into the query catalog.
> I never want to be caught saying "now where is that SQL for that query ?"
> "Wait ! it's somewhere here in these 10,000 lines of VBA code".
>
>
> >
> > Access routinely changes complex queries as you point out. Why use text
> > files though?  Why not vba modules so you can easily see and edit them?
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>