Form in Access 2000 opens really slow?
Posted on 2001-07-18
I have a form in a 2000 database that opens very slowly it takes at least 5 min. The form itself is not very complex. There is some basic command button coding on the form, and there are about 4 or 5 sub forms on this one form. Underlying the form and the sub forms are saved queries, not SQL. I think that this could be the problem but I'm not really sure. It only takes that long to load the first time if you close the form or go into design view the form will open quickly. But once you exit the database or access it will take a long time to load. I have done several other databases in 2000 and I have not had this problem before. (Unfortunately I did not design this database I'm just supposed to make it faster.) Any ideas would be welcome.