ScholarLens Back to search
2000•Apress eBooksRequires access

Optimizing Access for SQL Server

Russell Sinclair

Open publisher page 0 citations

Abstract

By now, you know most of what you need in order to move an Access application to SQL Server. I’ve covered how to create a SQL database, how to move your data, and how to use SQL Server data from within Microsoft Access. You are ready to begin or are well into your conversion from Access to SQL Server. But there is one more detail you need to know before you can complete your project, which is how to optimize your Access application for SQL Server databases. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

About this research paper

What this paper is about

By now, you know most of what you need in order to move an Access application to SQL Server. I’ve covered how to create a SQL database, how to move your data, and how to use SQL Server data from within Microsoft Access. You are ready to begin or are well into your conversion from Access to SQL Server. But there is one more detail you need to know before you can complete your project, which is how to optimize your Access application for SQL Server databases. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

By now, you know most of what you need in order to move an Access application to SQL Server. I’ve covered how to create a SQL database, how to move your data, and how to use SQL Server data from within Microsoft Access. You are ready to begin or are well into your conversion from Access to SQL Server. But there is one more detail you need to know before you can complete your project, which is how to optimize your Access application for SQL Server databases. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Key concepts: Business Intelligence Markup Language, Data Transformation Services, Computer science, SQL/PSM, User-defined function, SQL injection, Sql server, Stored procedure

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Optimizing Access for SQL Server — Research Paper | ScholarLens