I have several Access databases used as front ends only. They have links to tables in other Access databases that serve as the backend only. When we recently moved to a new server, we relinked all the tables but now Access is just crawling and I can't figure out why. Has anyone had this experience?
It is very bizarre to me that it takes over a minute to open a switchboard form. Neither this form nor the form that is opening it has any code other than the open form command and neither form has any sort of database access. Yet when I created a brand new Access file and imported all the objects from the problem one to the new one, I forgot to copy the 10 queries that are in the database. Without those queries, the accdb switches from one form to another instantaneously.
But when I put those queries back in, the form takes over a minute to open again. What I really don't understand is why are the queries even involved at all at that point. Like I said those in no data access involved and the form is not the first one to open in the application so I don't think it's a startup thing.
Any help would be GREATLY appreciated.