One of the key elements in successful client/server design is deciding where to put the data. The key to making this decision lies in recognizing and utilizing the strengths of each system. You are really designing two databases and establishing links between them. Although there are many techniques available to increase Microsoft Jet performance against ODBC data sources, the initial design of the data model will have the greatest effect on performance.
Note The information in this section applies to both Microsoft Jet and ODBCDirect Workspace objects.