Exploring Your Northwind Project

As mentioned earlier, it would take another book for a comprehensive analysis of SQL Server. Therefore, this chapter is just an overview. Even so, you get a taste of what is available to you if you take the time to explore the features of Microsoft SQL Server 2000 Desktop Engine. Actually, the engine has some very basic administrative tools, such as backup, restore, drop, copy, transfer, and SQL security. However, a project’s development features are not part of MSDE 2000 at all, but part of Microsoft Access. The bottom line is that, by using an Access project (ADP), you can build client/server applications including triggers, stored procedures, views, transaction logging, rollbacks, and so on, whether you use ...

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.