[AccessD] Access Queries

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?
On Feb 20, 2012 10:21 AM, "Mark Simms" <marksimms at verizon.net> wrote:

> Sorry Gary, I disagree. Even in Access 2010, there is still no ability to
> embed comments in the SQL.
> On top of that, any SQL formatting gets lost.
> And now couple that with a huge bug where AC2010 will actually CHANGE YOUR
> SQL without warning.
> That one bit me (embarrassingly so) at a client's location just last week.
> I now have created a procedure to store each Query's SQL in a text
> file...so
> it can be "restored".
> Bottomline: DO NOT USE ACCESS FOR COMPLEX QUERIES....YOU'RE GONNA GET
> BURNT.
>
> > I have offered to show people at my shop how to do queries in Access
> > but nobody takes me up on it. Things that I can whip out in a few
> > moments take hours to do using straight SQL on an Oracle Database
> > unless they are very simple. Anything involving 3 or 4 tables I will
> > have done far faster than they will. I love the query builder in
> > Access.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>