J
Joe
Hello all:
After upsizing an Access dB I (expectedly) encountered
several problems. The main problem being that none of my
queries upsized. I realize that I can re-write these
queries as views, but I'm running into trouble with
criteria. In most of my queries I reference forms in the
where statements using code such as:
WHERE (((tblConditions.strTestPlan)=[forms]!
[frmProductSpecific1]![cmbTestPlan]) AND
((tblConditions.strPlan)=[forms]![frmMainMenuList]!
[lstProduct])
Should I filter the forms? Can this be done in SQL server
views? Do I need to use stored procedures? If yes how?
Any help is greatly appreciated.
Thanks,
Joe
After upsizing an Access dB I (expectedly) encountered
several problems. The main problem being that none of my
queries upsized. I realize that I can re-write these
queries as views, but I'm running into trouble with
criteria. In most of my queries I reference forms in the
where statements using code such as:
WHERE (((tblConditions.strTestPlan)=[forms]!
[frmProductSpecific1]![cmbTestPlan]) AND
((tblConditions.strPlan)=[forms]![frmMainMenuList]!
[lstProduct])
Should I filter the forms? Can this be done in SQL server
views? Do I need to use stored procedures? If yes how?
Any help is greatly appreciated.
Thanks,
Joe