Navigation:  Articles >

Jun-2002

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

 

2002-06

 

---

 

Creating and Using Data Access Pages

Frank Kegley

1

 

Article

 

Although there are many ways to connect a database to the Web, they usually require some sort of specialized training. In this

 

article, Frank Kegley shows you how to connect a database to the Web using Microsoft’s Data Access Pages. While you’ll see

 

the p

 

Iron Rules

Peter Vogel

4

 

Editorial

 

You should apply at least the first three rules of normalization to your database design in order to get the best design. Like any

 

other rule, you must recognize when it applies and when it doesn’t apply…

 

Smart Search with a SQL Back End.

Nirmala Sekhar

10

 

Article

 

No database application is complete without a comprehensive search facility. Nirmala Sekhar extends

 

her search utility to harness the power of a SQL Server back end.

 

ad3468x60

 

 

 

Starting the Interface with Access Data Projects (part 2)

Martin Reid

12

 

Article

 

Martin Reid takes you into the world of Access Data Projects and SQL Server. Using a simple application, he shows you how to

 

leverage your Access skills to create views for your application. He then tackles the issues around ADP security that you’ll need
See part one in May-2002

 

Visual Access XP Review

Danny J. Lesandrini

17

 

Review

 

Microsoft Access is a two-fold blessing for programmers. In addition to being a fantastic development platform, its wide

 

popularity as an office productivity tool helps to sustain a market for user data reporting utilities. Savvy developers know how

 

to cash in on this opportunity by writing focused applications with a clear objective in mind. Does Visual Access

XP meet this litmus test? Danny Lesandrini investigates.

 

ADO and Subform Performance

Peter Vogel

21

 

Access Answers

 

Peter Vogel answers some thorny questions about using ADO to update a view (you can’t) and setting the

 

RecordSource property of a subform dynamically to improve an application’s performance.

 

Separate Your Data!

Renate Strub

23

 

Smart Tip

 

Renate Strub

---

 

Find all the PDFs and Downloads

http://www.vb123.com/smart/

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software