[AccessD] was SQL Server queries - appending strings

Hi John

> Now that I am changing to SQL Server I have to get the server doing more of
> the work - the whole point is of course to speed things up.  For technical
> reasons (a whole SLEW of reasons) going to an ADP is NOT an option any time
> in the near future, if at all.

[snip]

> What are my options here?  Do I have any?

An alternative to the other suggestions - which very quickly will turn
your job into a major project - you can connect to the server via
ODBC. Not fancy neither sexy and lacking "MS coolness", I know, but it
works; your efforts will minimize to moving only the tables to SQL
Server and walking through your code adding some dBSeeChanges ...

Of course, this depends on the client and his priorities. Does he wish
quickly to move the data to SQL Server? Does he pay for your time
turning the current app into an ADP (which is the "right" thing) or is
that in his eyes just a "learning experience" for you?

/gustav