Recent content by snappyfridge

I'm experiencing the same delay in bringing up the Field List in BOTH Layout View and Design View (e.g. 83 seconds for the first instance, then 35 seconds for subsequent instances while editing the same form).

What is Structure mode?

Tom - Any time I select the "Add Existing Fields" button in the Tools section of the ribbon, typically when I'm modifying a form in Layout mode. Regardless of the complexity of the form I'm editing, or the complexity of the query behind the form, I wait what seems to me to be an exorbitant...

Seems like Access is filtering through the entire list of every field in every table before showing the fields associated with the form layout view. It is debilitatingly slow. Any suggestions to improve speed?

Thanks so much for your reply. I'm going to review your comments and see if I can't make some headway.

Agreed. But I'm beholden to data sources created by others, and each year there are tweeks to those sources (field name changes, fields deleted/added, etc.) I have no control over those sources, so all I can do is react to the changes. That's the reason for the complete duplication of the system...

Hello, all. I've got a complex MS Access database that I duplicate each year (e.g. 2023 to 2024, so that I can refer to the complete database as it existed the previous year (for looking up historical records, etc.). When I perform this duplication, I update all the data sources from one file...

Thank you, Jon!

It's SnappyFridge, saying hello from New York, USA.