Updating links in access
If there are two columns in the bookmark, 20 values are passed in at a time to specify the next 10 rows.
In this example, there are only three rows in the table, so the final bookmark value, 3, which corresponds to the last Shipper ID in the table, is submitted eight times, because the rows are always fetched in sets of 10.
This occurs because sometimes the Office Access database engine determines that it cannot submit an entire query to SQL Server.
This white paper discusses several of these issues and presents strategies for resolving them.
Most of these issues relate to performance or updatability.
Select a template that shows TSQL to see all the statements being processed by the server.
From the client side, you can edit a Microsoft Windows registry setting that allows you to see the commands that the Office Access database engine is submitting to ODBC.