A2007 Slow typing

[Peter Hibbs]

I have a 2003 db which works fine. If, however, I run it using A2007
one form only runs very slowly. That is when you type text into a
field the first character shows up immediately but the next few
characters do not show until 5 seconds later, after that each
character shows immediately. There are no Events being triggered on
these fields, that is there is no code being executed when text is
being entered.

Also, when I close the form it takes about 15 seconds before the form
disappears from the screen.

The db is a FE/BE system on the same PC. The OS is WinXP and the CPU
is 3GHz Pentium so it should run at a reasonable speed.

The form that is slow has a Tab control with four sub-forms and the
main form is bound to a table with about 9000 records.

Does anyone have any ideas why it should run perfectly on A2003 but
slowly on A2007.

TIA

Peter Hibbs.

 

[Tony Toews [MVP]]

I have a 2003 db which works fine. If, however, I run it using A2007
one form only runs very slowly.

This has been reported a few times in the newsgroups. IIRC one person
stated that importing into a new MDB solved the problem. Try that
and let us know if that helps or doesn't.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Peter Hibbs]

Tony,

I tried importing the data into a new DB but it made no difference.

However, I think I have identified the problem (but not a cure).

If I set the 'Document Window Options' to' Tabbed Documents' instead
of 'Overlapping Windows' the problem goes away. Unfortunately the GUI
looks terrible because the DB has been designed with separate forms
and pop-up windows.

This also happens if the DB is running as a .ACCDB, it looks like a
bug in A2007 to me. If you have any other thoughts I would be
interested to hear them.

Peter.

 

[Peter Hibbs]

Tony,

It's definitely a bug, found a reference to overlapping windows
problems on Allen Browne's site which pointed to a hotfix at :-

http://support.microsoft.com/kb/943249/en-us

Downloaded this patch and it seems to be OK now. Hope this may help
someone else in the future, thanks again for your interest.

Peter Hibbs.

 

[Tony Toews [MVP]]

It's definitely a bug, found a reference to overlapping windows
problems on Allen Browne's site which pointed to a hotfix at :-

http://support.microsoft.com/kb/943249/en-us

Downloaded this patch and it seems to be OK now. Hope this may help
someone else in the future, thanks again for your interest.

Thanks for responding. I was unaware of that KB article.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Thanks for responding. I was unaware of that KB article.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/