Although Access can provide a very robust database, there are times when it just doesn’t have enough scalability or security for an application and alternatives need to be explored. In the past SQL Server was a viable solution, but it comes at an expense. Now there is a free version SQL Server 2005 called Express that is a free option that does not have the limitations that the previous free versions of SQL Server had. I this month’s main presentation we will learn about some of the advantages and pitfalls of upgrading your database from Access to SQL Server Express.
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.