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!