Query takes too long to go from SQL to DESIGN view and vice versa
I have a rather large Access 2K database (currently 700KB to 1.2KB depending upon when it was last compacted) that has started to exhibit extreme slowness when I go from SQL view to Design view and vise versa. XP Pro platform split front end/back end
For example, some queries take ten minutes or more just to switch views.
(Not to run the query, just from the time I press the design view button)
What can I do? This is a coding nightmare!
8/22/2022 - Mon
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat