Replies

Access 2007, I’m not using 2003, using 2000 for development

To recap:

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 same Access 2000 FE.mdb a second and subsequent times thereafter with Access 2007 if only takes 20 seconds which is normal

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

After further analysis, repeating step 1, 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

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

Hope this maks sense

John

After further analysis, I put 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 soot this?

Thanks, John

Keep your eyes open and report back if you discover any clues on post 757756

Access 2007 Opening FE.mdb the first time? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8)

Thanks, John

It happens only once, after a reboot, it opens normally in 15-20 seconds

I only have Access 2007 installed on the computer in question, however the symptom is similar to the following:

http://support.microsoft.com/kb/942378%5B/url%5D

· Access 2007 takes several minutes to repair itself

You install Access 2007 and Access 2003 on the same computer. When you run Access 2007 after you run Access 2003, Access 2007 takes several minutes to repair itself.
· You can still update the AutoNumber field data after you run an update query that sets an AutoNumber field to Null

Any thoughts?

John

Is there an official Access 2007 website that has all the latest SP’s & hot fixes?

Allen Brown’s site list Dec 16 ’08 hotfix as the last

Thanks, John

All MS & Office updates have been applied

About Access reveals:

Microsoft Office Access 2007 (12.0.6334.5000) SP1 MSO (12.0.6327.5000)

The links were very helpful!

Most of the links refer to Access 2003, do I assume they will work with Access 2000?

Thanks, John

Thanks for the links, they were very helpful

This is my first experience with 2007, on the surface it seems to be quite a new learning expericece.

Is there a classic GUI for Office 2007?

What has the end user acceptance been for Office 2007?

In the pass when I make even the slightest change to an application it takes much time for for acceptance in most cases.

John

Hi Tom

Can you share with us how you got your Custom Toolbar to work in 2007?

Thanks, John

Is this the one?

Don

You may be able to find components for your system for the price of a book

Check out the following

Re: How do I keep resource schedule from overlapping? (2000)
post 483438

HTH John

There use to be a demo here, don’t know the specifics!

Check Writer for Microsoft Access
http://www.databasecreations.com/demos.htm%5B/url%5D

Thanks for the information

Here you go!

(Edited by Claude on 12-Nov-08 13:54. link made non-clickable because of questionable code on the resulting webpage. I don’t know what they are up to, but it looks very suspicious to me, as jscher2000 points out below…)

Hi All

Check out System Explorer allows you to dive into all of these background operations. And it does it with better detail than Windows’ Task Manager.

http://systemexplorer.mistergroup.org

HTH, John