Microsoft Access + RAS

In the Microsoft Access model, we have a very different scenario than with SQL Server because the engine is located at the remote PC. This means that the records must be transferred over the modem to the engine for the query to proceed. Neither the query nor the result sets are transferred over the modem.

Our simplified measures reflect the change of engine location.

• Query transmission: 0 bytes
• Processing transmission: The maximum is 1024 x 20,000 (20,480,000) bytes and the minimum is 10 x 20,000 (200,000) bytes.
• Processing time on client: 1 second
• Results transmission: 0 bytes
• Latency: None assumed
• Elapsed time: At 14.4K baud, 111–11,400 seconds

The exact volume of data cannot be easily determined. We assume the contents of the AuthorState field and a record identifier are sent for the minimum size. The entire record is sent for the maximum size. The time ranges from 2 minutes to over 3 hours using these estimates. In both cases, the query takes at least an order of magnitude longer than with Windows SQL Server.