Access 2007 Opening Access 2000 FE.mdb the first time is Slow? 1

[JGravesNBS]

Using A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8

I’m New to Access 2007

I develop apps in Access 2000 and both FE.mdb and BE.mdb are in Access 2000 format

I have a user that is getting a new computer with A2007 preinstalled.

1. When I open the Access 2000 FE.mdb the first time with Access 2007 it taks 7 minutes to open

2. When I open the Access 2000 FE.mdb a second and subsequent times thereafter with Access 2007 if only takes 20 seconds which is tipically normal

There are no error messages and the application seems to work OK.

What is happening during the first opening of the FE.mdb?

After further analysis, I put a MsgBox in the On Open of my start-up form and it takes 7 minutes to get to the message box, then another 15 seconds to run all my start-up code and to my opening form which is normal

How can I further trouble shoot this?

Thanks, John

 

[lameid]

Because the FE is not in native format, Access 2007 is creating a hidden version of its type of objects in the FE folder. You should see the FE file get much bigger after Access 2007 opens it for the first time. Then anytime an earlier version changes any object, it detects the change and updates everything. I am surprised it takes that long to run through everything though. Also, a compact and repair with an earlier version will strip away the hidden version causing the recreation of the temporary objects.

 

[JGravesNBS]

Thanks for the information

How did you know that?

Is there a document available that describes

What is happening when Access 2007 opens an FE.mdb for the first time?

Thanks, John

 

[lameid]

I wish I could direct you to a source but I just picked it up somewhere in 10+ years of using Access.

Also I noticed I used folder in the first sentence where I clearly meant file...

Because the FE is not in native format, Access 2007 is creating a hidden version of its type of objects in the FE FILE[/color red].

 

[JGravesNBS]

Once the FE.mdb is opened in Access 2007 can it be safely reopened in Access 2000 to make changes then reopened in Access 2007 to run the the FE.mdb?

Thanks, John

 

[lameid]

Yes it can be reopened just fine in Access 2007. The catch is that it will recreate it's own temp objects everytime there is a change to an Access 2000 object. If you are not already doing so, I would highly recommend copying the FE to the client. This would reduce the stupid small changes that may be made like applying a filter that simply isn't worth 7 minutes. Also you could make a change to your local copy and make sure it is opened it in Access 2007 and push it out to a central distribution point. That way, only one person has to open the FE in Access 2007 for each change. There is a FAQ around an many posts about Front End's updating themselves.