Chapter 10 -- Working with Multi-User Databases

Chapter 10

Much of the rest of this book covers building Microsoft Access applications for groups of users. This chapter discusses some core multi-user issues: sharing files and controlling security. In reviewing file sharing, this chapter explicitly examines techniques and issues for sharing forms and recordsets. Subsequent chapters explore technologies for sharing Access databases, such as database replication, using Microsoft SQL Server, and using Access databases over the World Wide Web. This chapter assumes that you have a working knowledge of basic multi-user and security issues and focuses on new programmatic developments. For example, it includes samples that compare the new row-level locking with the more traditional page-level locking for recordset manipulation and samples that show how to control security programmatically with the new ADODB and ADOX libraries. The chapter closes with a sample demonstrating transactions in a multi-user environment.