Navigation:  Articles >

Sep-1997

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

Bronze Collection

1997-09

 

---

 

The Future of Data Access

Michael Corning

1

 

Article

 

An introduction to Microsoft's OLE DB and it's impact on data access.

 

Tip: Easily Display Properties

Steve Sarre

5

 

Smart Tip

 

A format for a routine to be called from the immediate window during debugging to display all of the properties for an object.

 

Active Data Objects

Michael Corning

6

 

Article

 

A discussion of how Active Data Objects, the first interface to OLE DB available to VBA programmer's works.

 

Blast off with ODBCDirect

Paul Litwin

10

 

Article

 

Paul outlines what ODBCDirect is, how it works, and what the benefits of using it are.

 

Updating RDO

Mary Chipman

15

 

Article

 

Mary and Mike bring readers up to date on the latest version of RDO.

 

Which to Choose

Peter Vogel

20

 

Article

 

Peter summarizes this issue's review of ADO, RDO, and ODBCDirect in terms of which data access method you should use. The

 

article also gives a brief look at Data Source Objects (DSO).

 

Tip: Don't End Any Field Name with "desc"

Steve Clark

22

 

Smart Tip

 

A note about a bug in Access 95 that occurs when sorting on fields whose names end in the letters 'desc'.

 

Tip: Getting the Math Right

Dana Ferguson

23

 

Smart Tip

 

A comment on an earlier article on handling floating point results that are calculated incorrectly in Access. A problem with the

 

FMS statistics package is pointed out and a simple work around for these problems suggested.

 

Tip: Controlling Time

Steve Sarre

23

 

Smart Tip

 

Some validation rules that allow the user to enter a free form date but prevent them from entering the time.

 

Access World News for September 1997 Issue

Paul Litwin

24

 

Access World News

 

A discussion of ELF 97 and Vision Builder 3. ELF 97 is the latest version of an natural language front end for Access. Vision

 

Builder is a CASE tool that generates Visual Basic programs and SQL triggers based on business rules (Vision Builder uses Access

---

 

Find all the PDFs and Downloads

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

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software