2000Apress eBooksRequires access

Using SQL Server 7

Russell Sinclair

Open publisher page 0 citations

Abstract

SQL Server 7 and Microsoft Access are very different systems, so in order to make your migration go as smoothly as possible, you should have a solid understanding of the basic functions you can use to manage SQL Server. Although Access 2000 allows you to manage portions of a SQL Server database through an ADP, and Access 97 allows you to manage some SQL Server database objects through the SQL Server Browser, neither version of Access gives you access to all of the capabilities of SQL Server. You should understand the tools available to you and how they can help you to manage your SQL Server databases.

About this research paper

What this paper is about

SQL Server 7 and Microsoft Access are very different systems, so in order to make your migration go as smoothly as possible, you should have a solid understanding of the basic functions you can use to manage SQL Server. Although Access 2000 allows you to manage portions of a SQL Server database through an ADP, and Access 97 allows you to manage some SQL Server database objects through the SQL Server Browser, neither version of Access gives you access to all of the capabilities of SQL Server. You should understand the tools available to you and how they can help you to manage your SQL Server databases.

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

SQL Server 7 and Microsoft Access are very different systems, so in order to make your migration go as smoothly as possible, you should have a solid understanding of the basic functions you can use to manage SQL Server. Although Access 2000 allows you to manage portions of a SQL Server database through an ADP, and Access 97 allows you to manage some SQL Server database objects through the SQL Server Browser, neither version of Access gives you access to all of the capabilities of SQL Server. You should understand the tools available to you and how they can help you to manage your SQL Server databases.

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

Related papers

Back to paper searchBrowse research topicsOriginal source
Using SQL Server 7 — Research Paper | ScholarLens