Date Filter slow to Load Access 2010

I have an Access application running in Access 2010 on Windows 7.  

When I right click on a date field and click on "date filters" to pull up the sub menu there is a delay that lasts several minutes.  If I leave it until it comes up then it will display the next time as expected.

It is not the filtering that is taking a long time, its loading the menu that takes forever.

Any thoughts?
LVL 1
mkacosAsked:
Who is Participating?
 
mkacosAuthor Commented:
I received an update last night to Access 2010 SP1.  I am now on version 14.0.6106.5005 (32-bit).  The problem has been resolved.  Thank you Microsoft for listening.
0
 
mkacosAuthor Commented:
Forgot one thing - This does not happen on all of the date fields in the form and it has not happened on any other field.
0
 
Helen FeddemaCommented:
Can you post the database so we can look at it?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mkacosAuthor Commented:
Helen

Not sure exactly what you are asking for but if you want the COMPLETE database then no, this table alone contains several million records.    

What exactly are you looking for?




0
 
Richard DanekeTrainerCommented:
Run the Performance Analyzer?
You may need an Index for the Date field in the table.   Since it runs faster after the first run.
0
 
mkacosAuthor Commented:
It already has an index that is rebuilt nightly.  This issue is loading the.menu.  not retrieving the data
0
 
mkacosAuthor Commented:
DoDahD - As a check, I rebuilt all indexes this weekend and the problem still exists.

Additional info: The problem first raised its ugly head on my system.  I am running Office 2010 Professional Plus with SP1.  I tried it on another machine that does not have SP1 and the problem is not near as bad.  Something that should pop up right away takes about 3 to 4 seconds without the Service Pak and about 5 minutes with the service pak.

0
 
mkacosAuthor Commented:
More information:


I have Office 2010 Professional with service pack 1 loaded.  On a system that does not have SP1 loaded this issue is not as bad.  None SP1 - takes about 4 or 5 seconds, with SP1 5 minutes.  Seems like anohter SP1 problem.


Even more information:

This form is tied to a query that uses a customer ID to select the records.  (Select * from [table name] where [customer id] = 'XYZ').  The Customer ID is indexed and so is the date field I am trying to work with.  All indexes have been rebuilt.

The SP1 5 minute result happens with a customer that has 490,000 (+-) rows.  I did the same test on a customer that has 39,000 (+-) rows and the delay is substantially shorter (about 15 seconds) but still not acceptable.


It looks like Access is querying the database to determine what options should be displayed in the pop up menu.  


This is a critical issue.
0
 
mkacosAuthor Commented:
MSFT issued an update that fixed the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.