Optimizing microsoft office access applications linked to sql server

Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! ODBC Drivers. New features. Quick access.

Search related threads. Remove From My Forums. Answered by:. Archived Forums. Access for Developers. Sign in to vote. I appreciate your help! Wednesday, July 9, PM. Recordset Dim i As Integer cmd. Update RS. MoveNext Loop cmd. Close End Sub Rich P. Van Dinh. The most important factor in query performance against remote data is ensuring that your server runs as much of the query as possible. The Microsoft Jet database engine attempts to send the entire query to your server, but evaluates locally any query clauses and expressions that are not generally supported by servers or by your particular server.

Functionality not supported by servers in general includes the following:. Operations that cannot be expressed in a single SQL statement. Often, you can rearrange your queries to calculate totals after all other operations. Servers differ in some areas of supported functionality. If the required functionality is supported by the driver and the server, the Microsoft Jet database engine sends the operation to the server for processing.

If not, the Microsoft Jet database engine performs the operation locally. Areas of differing support include but are not limited to the following:. Skip to main content. This browser is no longer supported. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. Small and Medium Business. Humans of IT. Green Tech. MVP Award Program. Video Hub Azure.