Slow Form in Access 2007 (end records)

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Hello:

My company is switching to Office 2007. I am opening my application in 2007
in mdb format.

Most of the things running much faster then in 2004. My main form is based
on query and there are about 30000 records. What happens is:

When I am on the first or beginning records everything is fast.

When I am at the end of the table and type data into memo field it behaves
like in small motion (I type faster then the text would appear)

If I go back to beginning then it is fast again.

Moving from record to record is fast...

Any ideas what would cause this behaviour? It is very fast in 2003.

I would appreciate your assistance.
 
Suggestions:

1. Make sure you have applied the service packs for Office 2007:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en

2. Make sure you have indexed any fields that the query selects on
(critiera) or sorts on (order by.)

3. If the database is not shared, make sure it's on your local drive. If it
is shared, make sure it's split, and each user has a local copy of the front
end. If splitting is new:
http://allenbrowne.com/ser-01.html

4. Address the issues Tony Toews mentions here:
http://www.granite.ab.ca/access/performancefaq.htm
such as turning off subdatasheets, name autocorrect, and keeping the path
names short.
 
Hello Allen:

Thanks for your advise. Actually, I followed on your number 1 paragraph and
applied Office 2007 service pack 2. Database and application performance is
very fast now.

Thanks so much,
 
Back
Top