<div>
<div class="content wysiwyg-content">
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 &quot;conventional&quot; 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.<br />
<br />
Can someone educate me here on this before we spend a lot of time doing something that might not be correct.
</div>
</div>


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.

Updateable Pass Through Queries

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.