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

 

[mrshl9898]

Looks like this should be it. I've only used it in Excel.

How to Use SQL with Microsoft Access - dummies

Microsoft Access is a rapid application development tool that doesn't require programming. Here's how to use SQL statements with it.

www.dummies.com

 

[JRSam]

If I understand well access can't use query created in SQL server except those created in access itself as pass-through query. Am I right?

 

[mrshl9898]

Sorry, realised that wasn't quite right and have been looking in here but got held up on calls.

I can add our server name, and find a side of it I haven't seen before system tables. But i'm struggling to find our databases.

Have you added your server?

 

[mrshl9898]

Got it, from there: Importxxx tickbox and OK; New: Select SQL Server and hit Advanced: type in server and DB details:NEXT:NEXT:type any name and next and FINISH

*that's the process now, though i'm sure another pop up had me confirm the DB name earlier.


So much more tedious than Excel, apologies for rushing the initial response.

 

[JRSam]

Yes my front end is already linked to the SQL server.

I got also my pass-through query.

But in my BackEnd(SQL Server), When I create a query, it is being saved in a folder. Is it possible that my Front End of Access be linked to the Query created in from SQL Server?

Because right now I have only all my tables linked and my pass-throug query linked

 

[mrshl9898]

I don't entirely follow your process sorry. In SQL Server I write a query against the Database on a SQL Server. In Access I am doing the same thing, no saving of the query in between.

Sorry for not fully understanding what you were after.

 

[JRSam]

Perhaps it is the way I explaining the situation. I'll try with photos

 

[JRSam]

Hope this can help

 

[mrshl9898]

Unless one of the new data source links has that same file extension I'm clueless