Performance problem in one form only

I have multiple forms in my database but one of them has been giving me a
performance problem (Very slow) recently. I have tried shortening form and
removing subforms but this did not help.

When I run performance Analyzer, it suggests I create some relationships
between tables but I already had set these relationships up in the query on
which the form is based.

Interestingly problem is not always present but it does recur when I "compact
and repair database".

Any ideas? Thank you for the help in advance.

Just an observation but setting relationships in the queries is not the same
as setting relationships as proper relationships. For example you can't
enforce referential integrety or do cascading deletes.
Relationships can be seen in MySysRelationships and relations between tables
in a query can be seen in MySysQueries.
Te see these tables you need to select on the Database
Tools->Options->View->System objects

HTH

Phil


"MFS 43" <mfs43@aol.com> wrote in message
news:20031226005826.12189.00001802@mb-m05.aol.com...[color=blue]
> I have multiple forms in my database but one of them has been giving me a
> performance problem (Very slow) recently. I have tried shortening form and
> removing subforms but this did not help.
>
> When I run performance Analyzer, it suggests I create some relationships
> between tables but I already had set these relationships up in the query[/color]
on[color=blue]
> which the form is based.
>
> Interestingly problem is not always present but it does recur when I[/color]
"compact[color=blue]
> and repair database".
>
> Any ideas? Thank you for the help in advance.[/color]

Thanks for the thought --- will look into setting up relationships better.