How to Use a Pass Through Query in MS Access - SQL Server Example

Just passing through? :-D So, what was it that made you choose a pass through query in your project? Performance bottleneck?

Thanks you so much Sean!!! Is there anyway run a stored procedure, using a passthrough query, that has input and output parameters? if so, how can I retrieve the output parameter value in Ms access?

I’m late to the party, but can this technique be used to set the record source property on a form?

I’ve just recently started migrating Access databases to SQL server

Exactly what I was after, this channel is brilliant for those old access people moving to sql, thanks heaps :)

I am migrating a whole bunch of Access applications to SQL Server. Quite often the forms and reports of applications are (rather poorly, IMHO) designed based on RecordSources like "select * from table_x where column_y = Forms!form_z!textBox_t". Whatever solution I implement on the SQL Server side, I'd need to change the query on-the-fly, as you explain here, and requery, right?... No other ways to "dynamically inject" the Forms!... value, then?!

I have a pass through query which finds the opening balance from few SQL tables processed in SQL. but sometime it seems that the passthrough query is not showing all the balances hence when the query is run different times I get different results. please let me know if there is a way to see if the query has run or nut (VBACODE)

excellent work

Very Nice Explanation..

thanks

I'm new to using MS Access and this information helped me tremendously. Do you have any videos about creating expressions specifically around date functions. I need to find a way to update a field with a new date when another field is changed.

Is it possible to change o define the connection to a pass trought query with vba? If is possible, could you please make a video explaining how to do this? Thanks for your help.

awesome video!

What if i don't have the authority to create procedure?

Excelent explanaion. Thanks