jgoodman00
Programmer
- Jan 23, 2001
- 1,510
I posted a question a few months back regarding forms being slow to load. I have now found the reason (in my case) for this, & it is not what I expected.
I am using Access XP, but I believe this also applies to Access 2000.
Find the slowest loading form in your database & load it. Time how long it takes to load.
Next goto Tools-Options & select the General tab. On this tab there is an option group called 'Name Autocorrect'. If this is enabled, disable it.
Reopen your form. In the case of every database I have tried, this speeds up loading several times over!
It seems strange how this option can cause such a performance loss though... James Goodman
I am using Access XP, but I believe this also applies to Access 2000.
Find the slowest loading form in your database & load it. Time how long it takes to load.
Next goto Tools-Options & select the General tab. On this tab there is an option group called 'Name Autocorrect'. If this is enabled, disable it.
Reopen your form. In the case of every database I have tried, this speeds up loading several times over!
It seems strange how this option can cause such a performance loss though... James Goodman