To run a query on a database server, use a pass-through query which is a Transact SQL (TSQL) statement that connects to SQL Server by using an ODBC connection string. You do this to help improve performance: database servers have greater processing power than a desktop computer and you can return a smaller subset of data over the network connection. Often though, you want to explicitly run a query on a database server. For more information, see "JET Database Engine Version 3.0: ODBC Connectivity" in Rediscovered JET and ODBC white papers. In some cases, Access can run a query remotely on SQL Server, depending on the SQL syntax and other factors. By default, most queries run locally in the Access ACE database engine. You can use Access as a front-end application and then link to tables in a back-end server, such as SQL Server. ![]() Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 More.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |