How to Use Query Created in SQL Server with a Front End Ms Access

[JRSam]

Hi everybody,

I am new to SQL server. I have been using Ms Access for nearly 6 yrs. Now That my database have grown in data, I decided to use SQL server as backend and Ms access as front end.

Right now I am learning all the steps to migrate my Ms Access backend to SQL server. But right now I would to know how to use a query created in SQL server by the Front end of Access. Is it possible?

Of course I have pass-through query resided in front end Access but what about a query created in SQL Server. Is it possible to use it by the Front end?

If yes, please step by step how. Thanks

 

[JRSam]

Thank you for your precious help.

 

[james_lankford]

> When I create a query, it is being saved in a folder

you don't save files in sql server like you do in access
you can't write some sql commands and save like you can in access
what you can do is create a stored procedure
SQL Stored Procedures

A Basic Guide to SQL Server Stored Procedures

This tutorial shows you how to manage stored procedures in SQL Server including creating, executing, modifying, and deleting stored procedures.

www.sqlservertutorial.net

creating a stored procedure is sort of like creating a table
you write some sql commands and save them as an object in the database
but instead of the object being a table its a stored proc
you use a passthrough query to run the stored proc and have its results returned to you

 

[JRSam]

> When I create a query, it is being saved in a folder

you don't save files in sql server like you do in access
you can't write some sql commands and save like you can in access
what you can do is create a stored procedure
SQL Stored Procedures

A Basic Guide to SQL Server Stored Procedures

This tutorial shows you how to manage stored procedures in SQL Server including creating, executing, modifying, and deleting stored procedures.

www.sqlservertutorial.net

creating a stored procedure is sort of like creating a table
you write some sql commands and save them as an object in the database
but instead of the object being a table its a stored proc
you use a passthrough query to run the stored proc and have its results returned to you

Thank you. Now I understand. I was getting confused the way we use query in access.