[thelist] Access SQL Approach Strategy Needed

Rob Smith rob.smith at THERMON.com
Wed Sep 17 08:13:00 CDT 2003


Hi list,

A colleague of mine has 'this' Access 97 database. Some of the queries use
the [Variable :] syntax, which prompts the user to enter data. However,
these queries are slowly but surely being transformed into pass-through
queries. Prompting for variables isn't a viable solution anymore. Without
using forms... is there another strategy I can use to get a prompted
variable value into a pass-through query before it gets sent off to the SQL
Server?

Thanks,

Rob.Smith


More information about the thelist mailing list