Category Archives: Old Material

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

Posted in Old Material | Leave a comment

Preparing To Upgrade Access Tables to SQL Server 2005/2008

This article discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. I do this because once you are in an environment where you have Access as a front-end … Continue reading

Posted in Old Material | Leave a comment

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

Posted in Old Material | Leave a comment

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

Posted in Old Material | Leave a comment

Remote Queries in Access

This technology no longer works in Access 2016 What Is A Remote Query ? It always amazes me how I can keep stumbling across features that I never ever noticed or read about in the 8 years that I have … Continue reading

Posted in Old Material | Leave a comment