Hi Adam,
Read 'The Twenty-Something Rules For Access Development'
in the Group Files 'Articles_Excerpts' folder if you
have not seen them and implment them.
There could be a problem with indexes. If you have
too many, or too few, you can get slow performance.
Make sure all Tables have Subdatasheet_Name set to
[None] for a start. Use the following link,
http://thatlldoit.com/codesamples.aspx
to get a free utility from Bill Mosca that will do it.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "AdamF" <runuphillracing@...> wrote:
>
> A series of forms suddenly take a long time to open (~30 sec). All of the forms have multiple sub forms. The culprits are either the same sub form, or sub forms that share the same data source. When I open the sub forms alone, or the underlying query, they seem to open fine.
>
> I haven't made any changes to the forms, sub forms, or underlying query. There isn't any code on the sub forms. I've gone back and run prior versions, before it was slow, and they are slow now too. I'm guessing this implies that it's something with the underlying tables, but I have no idea what that might be.
>
> How can I trace what's causing the delay?
>
> Adam
> Denver, CO
>
Tidak ada komentar:
Posting Komentar