By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Performance problem in one form only

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <mf***@aol.com> wrote in message
news:20***************************@mb-m05.aol.com...
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.

Nov 12 '05 #2

P: n/a
Thanks for the thought --- will look into setting up relationships better.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.