MS Access 2007 .accdb extremely slow

Question

My company will be upgrading from Access 97 databases to Access 2007. I have created an .accdb file and have imported the objects from the Access 97 .mdb file. The problem now I see is that even clicking on a button that just opens a form (no significant code behind it) takes 5 min. Going into a design mode for a form takes like 3 min. What could be wrong here?

I compared this with the MDE version of this file that I created and no problem. Clicking on the button, the form loads right away. But this should not be happening just because it's an .accdb file. Am I doing something wrong here?

Answer 1

Before you import any objects have you compacted and repaired and cleaned your database? Also is your data split between the forms, reports, etc. In addition, do you have an MDB BE (back end) that has tables and the MDB FE (front end) has only a link to the tables. If you don't you may want to consider it. First try a compact and repair from the tools menu.