Category Archives: Old Material
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.
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
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
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