Microsoft Access 2003 review:2 stars (Caveat Emptor) - If you're thinking of buying MS Access 2003 there are a few things you need to consider:

1) Microsoft's new licensing/activation requirement for Office products. Office is a serious cash cow and Microsoft are tired of letting people copy it and use it illegally/for free. Access 2003 has a few new features that Access 2000 and 2002 didn't offer, but for most of us they are not worth it - unless web services, xml, smart tags and wizards turn your crank. If you're anything but a developer, most of Access 2003's new features will not be relevant to you.

2) Access is in some respects a powerful database and client-server front-end program and it may be too much for your needs. Using Access can be as simple or complicated as you let it - and it can get very complicated. If you are a small-business owner trying to get organized, you should probably consider another tool like Filemaker. If, on the other hand, you really want to get a handle on things and are prepared to invest some significant time to learn Access and your business and your database needs are growing, then Access might be for you. It is not an easy tool to use, but it is pretty powerful and a lot more usable than middle-market desktop database development tools like FoxPro and Paradox.

3) If you are a small/mid business user and have heard that Access is a great front-end for the free MySQL server-based database engine, also caveat emptor. Access uses ODBC (Open Database Connectivity) to work with MySQL and the implementation is not great so you'll quickly run into some (though solvable) strange problems... and though you could never argue with the price, MySQL itself is a bit on the not-user-friendly side - and finding support when you have a problem is tough.

4) If you are a SQLServer user, or plan to be at some point and intend to use Access as a starter database that you'll eventually migrate to SQLServer (2000 or 2005) or SQLServer Express (2005), then caveat emptor. Microsoft is punting SQLServer Express as their new low-end database - a free version of the bigger SQLServer to compete with MySQL and replace the somewhat clunkily-named and clunkily-implemented MSDE (Microsoft Desktop Database Engine). The new versions of SQLServer are fully committed to Microsoft's .Net platform - essentially a new common platform for new Microsoft products and development tools - which Access/Office is not a part of. Traditionally, many have used Access as a front-end for SQLServer or MSDE databases. Access has provided a great front-end capability for the more grown-up and complicated back-end database servers. The only doubt on the horizon is whether Microsoft are committed to supporting Access properly with future versions of SQLServer. Access Data Projects (an access database front-end for SQLServer 2000) appear to be on the chopping block. You may still be able to use Access files with "linked tables" to access newer SQLServer versions but they can be more difficult to develop and are less than optimal for anything but small database applications. And if you do fit in this category, why would you consider developing a database application at considerable expense when it might not be completely supported by Microsoft in future?

My very personal feeling is that Access is not long for this world. Access as a database application is caught between trying to be a serious database development tool with support for upstream Microsoft products and being a usable database application for small businesses. It appears that increasingly it is not effectively addressing either role. It started life as a serious database tool and then was opted into the Office product lineup where it has pretty much floundered ever since, while SQLServer has been the focus of Microsoft's attention. Sadly, Microsoft seem to have missed the opportunity to develop Access as the stand-alone database and front-end to SQLServer that it could have been.

Ironically, I have been using Access since the first version came out about 10 years ago and, having taken the time to learn it, find it to be an incredible tool for databse front-end development. But it appears that this product is nearing the end of its useful life mostly because Microsoft seem content to not invest much in the product. I certainly hope that Microsoft are just keeping their plans for an Access .Net version that will again integrate with SQLServer quiet, but indications are that there are no such plans.

5 stars (If you are a database programmer, Access is simple, easy) - I use Visual Foxpro and found Microsoft Access a breeze after I have struggled with VFP for so many years. No object classes, form sets, etc.. Can anyone ever really "know" Foxpro? If you are a database programmer, you will find Access simple and easy to use. Create your switchboard and run only macros from it to launch forms, which in turn, can launch another macro from a button on the form that will run the action queries and the reports. It helps to know some Visual Basic but its not mandatory. It doesn't get any easier than this but I say this as a database programmer. If you are not a DB programmer already, get a little help in the beginning from someone who develops applications with Access. Before you know it, you will be rolling out applications with ease. 1 stars (their is something much better) - After trying access (xp version) and reading several books I still wasnt able to create much of a usable database. Now that I tried Filemaker Pro 7 I will never ever attempt to use access again. Save yourself and your sanity; get Filemaker Pro
Microsoft Access 2003 Features:
Computer software (programs)
Database (Databases)
CD
Quickly find tables, queries, forms or reports that depend on a particular database object
Update properties automatically
Supports a variety of data formats, including Extensible Markup Language ( XML ), OLE, Open Database Connectivity ( ODBC ), and Microsoft Windows SharePoint Services
Access data from multiple databases in forms, reports, and data access pages, linking tables from other Access databases, Microsoft Excel spreadsheets, ODBC data sources, Microsoft SQL Server databases & other sources
Stored Procedure Designer creates & modifies procedures stored in SQL Server, without requiring you to learn Transact-SQL

Microsoft Access 2003 is the CD-ROM version. The full version can be purchased by clicking on the "CLICK HERE TO ORDER" button below for around 194.99USD.