Category Archives: Old Material
Using Access to Prototype for SQL Server
As Jamie shows, even when you’re working with SQL Server, Access can have an important role to play. Here’s what to do to make sure that you get the most out of using the two tools together.
Working with or without a DSN
This month, Doug Steele answers questions about connecting to external databases like SQL Server and Oracle. Okay, I know how to work with desktop data sources other than Access, such as Excel or dBase. What about using other databases such … Continue reading
Stored Procedure tricks
If you’re using SQL Server as your back-end database, you’ll get your best performance by using stored procedures. Here, Michael McManus showcases some standard routines to make using those tools a little easier. As Mary Chipman and Mike Gunderloy emphasized … Continue reading
Silence
Just before Christmas, I received news that Chris Bell had died. Smart Access readers will know Chris from his contributions to this newsletter, especially his effort in pulling together the M-Files article (see “The M-Files: MVP Solutions to Your Biggest … Continue reading
Saving Reports is a Snap
In this article, Garry Robinson presents a routine that will allow you to save Access reports directly into Snapshot format. This year in Australia, a new tax law was passed. Guess what! Invoice reports for most companies had to be … Continue reading
