Microsoft Access 2010 Bible

Chapter 21: Building Multiuser Applications .............................................................................. 753 F ...

Part III: More-Advanced Access Techniques 754 All files on the client In this scenario, you have all executables — .exe files, . ...

Chapter 21: Building Multiuser Applications 755 ODBC and client-server applications are in high demand, so you have to find an a ...

Part III: More-Advanced Access Techniques 756 LISTING 21.1 (continued) Do While Not rs.EOF rs.Edit rs![ReviewDate] = DateAdd(“yy ...

Chapter 21: Building Multiuser Applications 757 You can easily change the open mode of an Access database. In the Open dialog bo ...

Part III: More-Advanced Access Techniques 758 LISTING 21.2 Using ADO to Open a Database Exclusively Public Sub OpenDatabaseTest_ ...

Chapter 21: Building Multiuser Applications 759 Splitting a Database for Network Access One common technique employed by many ex ...

Part III: More-Advanced Access Techniques 760 database file. Assume for a moment that the entire database is contained within a ...

Chapter 21: Building Multiuser Applications 761 FIGURE 21.3 A database kept on a file server can generate a large amount of traf ...

Part III: More-Advanced Access Techniques 762 The local .accdb also contains all the user interface objects, including forms, re ...

Chapter 21: Building Multiuser Applications 763 The only other information that the Database Splitter requires is where you want ...

Part III: More-Advanced Access Techniques 764 Figure 21.6 shows the Access Database Explorer after splitting the Northwind Trade ...

Chapter 21: Building Multiuser Applications 765 When using record-level locking, Access locks only the record currently being ed ...

Part III: More-Advanced Access Techniques 766 Default Open Mode The Default Open Mode setting in the Advanced tab of the Access ...

Chapter 21: Building Multiuser Applications 767 Refresh Interval In multiuser environments, data is extremely volatile because i ...

Part III: More-Advanced Access Techniques 768 Update Retry Interval This option controls the period of time Access waits to retr ...

Chapter 21: Building Multiuser Applications 769 You’ve gotten a taste of what can happen in your multiuser applications: Perform ...

Part III: More-Advanced Access Techniques 770 In a DAO environment, use the LockEdits property (a Boolean) of a Recordset object ...

Chapter 21: Building Multiuser Applications 771 Set cnn = Nothing Exit Sub HandleError: ‘Update Retry Count: lngTryCount = lngTr ...

Part III: More-Advanced Access Techniques 772 LISTING 21.4 (continued) HandleError: ‘Update Retry Count: lngTryCount = lngTryCou ...