Updateable Pass Through Queries
Posted on 2004-11-14
We recently migrated our Access 2002 backend to SQLserver and attempting to isolate performance bottlenecks. Most of the forms we provide for customers to do data entry have a "conventional" SELECT query as it's recordsource. I've been told these queries should be Pass Through queries instead but then I've also been told you can't use a Pass Through query on a data entry/edit form.
Can someone educate me here on this before we spend a lot of time doing something that might not be correct.