When developing multiuser applications with Microsoft Jet, you may find it helpful to split your objects into two databases. This approach offers many advantages. These two databases are known as the front-end database and the back-end database.
The front-end database has three basic characteristics:
The back-end database contains the tables that hold your application’s data. The tables in this database are accessed by your application through links in the front-end database. Figure 6.4 illustrates the two-database approach.
Figure 6.4 The two-database approach
See Also For more information about linking tables, see Chapter 8, “Accessing External Data.”
The advantages of the two-database approach become obvious in multiuser environments. First, by storing the front-end database on the user’s workstation, there is no contention for temporary objects because your application doesn’t have to worry about creating a temporary table that may conflict with another user. Second, by storing application-specific objects that are typically static in nature at the local level, the amount of network traffic that occurs while your application runs is minimized.