Hi Experts! I'm working on trying to speed up an Access 2010 application with an ODBC connection to SQL Server. I came across the CacheStart function and have no idea how to deploy it. I don't understand how too set the cache size, etc.
One form has 1.5 million records behind it.
Most combo-boxes are populated with Passthrough queries which have sped up the form to some degree -- but I really need help.