Slow Form in Access 2007 (end records)

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.



--
Anna

Suggestions:

1. Make sure you have applied the service packs for Office 2007:
http://www.microsoft.com/downloads/d...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 he
http://www.granite.ab.ca/access/performancefaq.htm
such as turning off subdatasheets, name autocorrect, and keeping the path
names short.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Anna" .(donotspam) wrote in message
...
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.

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,
--
Anna


"Allen Browne" wrote:

Suggestions:

1. Make sure you have applied the service packs for Office 2007:
http://www.microsoft.com/downloads/d...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 he
http://www.granite.ab.ca/access/performancefaq.htm
such as turning off subdatasheets, name autocorrect, and keeping the path
names short.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Anna" .(donotspam) wrote in message
...
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.