| re: Performance problem in one form only
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] |