Other Topics > Smart Access 1996-2006 > Apr-2001

Apr-2001

<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >

Apr-2001

 

Smart Access Article Abstracts

Page

 

 

2001-04

 

---

 

Improving on VBA with Transact-SQL

Burton Roberts

1

 

Article

 

In this article, Burton Roberts demonstrates some of the advantages of writing procedures for SQL Server stored procedures and functions instead of VBA functions and subs.

 

 

 

A Special Issue: Moving to SQL Server

Russell Sinclair

4

 

Editorial

 

Russell Sinclair writes "When I did my first migration from Access to SQL Server a few years ago, I attempted to do a simple migration. I thought that if I just migrated the tables and data to SQL Server and linked the tables  (you know the story)

 

 

 

SQL Server Security for the Access Developer

Andy Baron + Mary Chipman

8

 

Article

 

There’s a lot to learn when working with SQL Server security from an Access application. In this article, Mary Chipman and Andy Baron introduce some basic SQL Server security concepts and discuss the choices you have when implementing SQL Server security

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Choosing the Right Data Source

Russell Sinclair

17

 

Article

 

Choosing between views and stored procedures in order to access SQL Server data can be confusing. In this article, Russell

 

Sinclair covers the information you need in order to make the right choice.

 

Using Forms in ADPs: What You Need to Know

Mike Gunderloy

19

 

Article

 

With Access 2000+, Microsoft made some major changes to its venerable database. One of these changes was the addition of Access Data Projects (ADPs), which use SQL Server instead of Jet as their database engine. At first glance, the user interface of ADPs

 

 

 

 

---

 

 

 

---