Summary

Building secure solutions is a vital activity for any database developer. Chapter 10 explores and demonstrates techniques for building secure Jet database solutions. This chapter does the same for SQL Server solutions. In addition, you learn about uses for SQL-DMO that extend beyond SQL Server security. In particular, the chapter presents a database and object explorer that lets a user explore databases and objects on the local SQL Server instance from an Access form. In addition, the chapter presents programmatic means for attaching and detaching databases via SQL-DMO. These techniques are convenient when you want to move databases from one computer to another.