Small Access databases don't usually have performance issues - but small databases have a habit of growing up to become big databases with slow response times, and then you as the developer are faced with fixing it. In this presentation, Wendell Bell will explore the kinds of performance bottlenecks you are likely to encounter, and various methods of improving the situation. Topics to be covered include the judicious use of indexes, dealing with LAN performance issues, masking performance issues with the user interface, when to consider upsizing to SQL Server, and performance issues with WAN or web interfaces.
Wendell has been an active user of Microsoft products since 1986, began his consulting practice in 1990 after spending 27 years with AT&T and Bell Labs, and since 1994, has been specializing in using Access as a front-end to SQL Server. He and his partner Kevin have deployed more than 100 production databases in Colorado and other cities around the world. In addition, Wendell serves as a moderator for the Access forum on the peer-to-peer help site known as Woody's Lounge - it can be found at www.wopr.com/lounge - and you can read more about his background and avocations at www.access-experts.com.
As Access Applications mature, they tend to get more complex, are used by more people and often become a critical tool for a businesses success. While performance issues are usually easy to spot, bulletproofing an application is an exercise in predicting what can go wrong, and reacting to it before it happens. In addition to protecting your users from a bad computing experience, you also need to be concerned with protecting your application’s data and intellectual property from prying eyes. While even the most robust database application is no match for Dirty Harry, there are several tricks that can help make your Access application more stable and secure. In this presentation we will explore several different strategies for making your application more robust and maybe even bulletproof.
Kevin has been developing custom business solutions with Access since version 1.0 and SQL Server since version 4.21. Over the years he and his partner Wendell, have deployed more than 100 production databases in Colorado and other cities around the world. Visit their web site at www.access-experts.com for an Access tip of the day.
The Denver Area Access User Group hosts its annual Holiday party on December 18th. This is the annual "let your hair down" user group meeting. Holiday refreshments and goodie give-aways rule the evening.
Although we will not be having a full length main presentation, sometime around 7:30 we will be having one of our expanded Thirty (Sixty???) Minute Topics.
The majority of the meeting is for members and visitors to meet, relax, and chat. Door prizes and an evening-long drawing highlight the gathering.