[AccessD] SQL Queries vs. String SQL

Well, perhaps for some Access developers. But I had the fortune to migrate
to ADP back in Access 2000, and after the first migration (no, make that
"During"), I wrote said utility to grab every RowSource and RecordSource
that began with the word "SELECT". The rest was trivial. Not only that, but
the benefits were obvious even sticking with an MDB BE. For example, a
combo-box RecordSource presenting CustomerID, formerly a SELECT statement
on several forms, now a named query Customer_qs (my convention: the suffix
in this case indicates Query Select).

I think that God, in creating man, somewhat overestimated his ability.

-- Oscar Wilde

On Sat, Jan 28, 2012 at 12:36 PM, Mark Simms <marksimms at verizon.net> wrote:

> No doubt about it. However, I have a funny feeling that 90% (or more)
> Access
> apps worth migrating have NOT used cataloged Access queries for
> recordsources. Then add to that all of the dynamic "string SQL" in
> VBA....and you've got a nightmare of a conversion project.
> Strange that Microsoft didn't provide adequate guidelines from the
> beginning....now it's too late !
>
>