Performance Analyzer Question

[KitCaz]

I'm running the MS Access Performance Analyzer on my front-end database (so I
can analyze forms/reports, etc.). I received suggestions re: adding indexes
and relationships I otherwise missed.

If I let the Performance Analyzer perform the optimizations, will it be
doing so to the front end or back end database?

And a related question--where should I be defining my relationships? On the
back-end database (in which case does the front-end refer to these/inherit)
or to both?

Chris

 

[Klatuu]

Relationships are defined in the database where the tables are.
Any front end linked to the back end is constrained by the relationships and
properties defined for those tables.

 

[KitCaz]

Thanks, Dave.

So to be clear, when I open my front end database I see relationships, as
well as in the back end. Are these independent? Can they be made out of
sync? Not desirable I'm sure but I want to know 1) if I delete them on the
front end will the back end relationships prevail, 2) if the relationships
old/out of date on the front end will the back end relationships supercede
and 3) if they exist in both places is there extra effort being made to
enforce them twice?

Also, do you know whether the Performance Analyzer makes its changes to the
front end database when one selects to Optimize from this tool, and if so, is
it better to just note the suggestions and make them to the back end database?

 

[Klatuu]

The relationships exist only in the mdb where the tables are. You cannot
have different relationships defined in the front end. You cannot modify
realtionships in the front end. It has to be done where the tables are.

Think of Access as a collection.
For data, you have Jet which is a database engine.
For application development, you have forms, queries, controls, macros,
You also have VBA as the programming language
You have reports - the report writer.
In many environments, you need to collect all the pieces yourself and make
them work together. For example, with traditional VB you needed VB for the
application development, SQL Server or some other database engine for the
data, and Crystal or some other report writer. Access gives it all to you in
one package.

As to the performance analyzer, I have to plead some ignorance. I really
have not used it, so I cant testify to how much value it has or what database
it affects. I would guess it would have to be the database file where the
issue is. As earlier stated, you can't modify tables, realtionships, or
indexes in the Front end. The live in the back end.