Navigation:  Articles >

Jan-2001

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

 

2001-01

 

---

 

Temporary Tables with No Bloat

Doug Den Hoed

1

 

Article

 

Temporary tables are great for extending query functionality, storing transient data, and solving concurrency issues.

 

Unfortunately, using a linked Jet table to store that data will cause database bloat. This month, Doug Den Hoed shares his

 

technique for

 

Access Applications

Peter Vogel

4

 

Editorial

 

One thing that I keep being asked to do is review Access applications that developers are preparing to market commercially.

 

I’ve seen three in the past three months, and they’ve all been very interesting, ranging from sophisticated service billing

 

systems

 

User-Driven Menus

Keith Bombard

10

 

Article

 

If you’ve ever worked with Access to develop large, multi-user databases with thousands of objects, then you’ll want to think

 

about limiting user access to those objects. In this article, Keith Bombard shows you a simple and proven technique to manage

 

acc

 

Everything Doesn't Happen at Once: Loosely Coupled Events

Peter Vogel

13

 

Article

 

If you’re running Access on a Windows 2000 computer, you can take advantage of COM+ to build more sophisticated applications. Peter Vogel looks at using

 

Loosely Coupled Events to create applications that run asynchronously.

 

Data Projects and SQL Server

Andy Baron

17

 

Article

 

This month, Andy Baron returns with a variety of answers that focus on issues related to using Access with SQL Server.

---

 

Find all the PDFs and Downloads

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

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software