We have an access db that is growing. The issue we are having as we create more and more forms is a growing lag when switchin to design view on many forms. It also lags a lot when viewing the "Add Existing Fields" or sometimes after it updates the SQL code behind the form's recordsource it will take a very long time. Access itself freezes up during these situations. It sometimes take 2-3 minutes to get control of access back. How can we fix this?
Start Free Trial