Question regarding relationships

[Don Garry]

I have a networked database that I have split into a front-end and back end.
The front-end being the queries, forms, reports, code, etc. in a mde file
and the back-end being just the tables with data in a mdb file.

My question is regarding relationships.

Is it better to have the relationships stored in the front-end or back-end
or does it matter ?

If it is one over the other what are the benefits ???

Any guidance or assistance on this question would be really appreciated.

 

[John Vinson]

Is it better to have the relationships stored in the front-end or back-end
or does it matter ?

They must be defined in the backend. Relations defined in the frontend
are decorative only.

If it is one over the other what are the benefits ???

Relationships, to be enforced, must be in the same database as the
tables that they relate; because if a relationship is defined in A.MDB
to enforce relational integrity between tables in Z.MDB, there is no
way that A.MDB can do anything to enforce those relationships, if
someone opens Z.MDB directly (or from QRSTU.MDB).


John W. Vinson[MVP]