I have been asked if there are any functional problems with a database having
only relationships defined by queries. Will it be stable? Will there be
issues and if so of what nature? Thanks!

On Wed, 23 May 2007 12:48:03 -0700, Cheese <(E-Mail Removed)>
wrote:

>I have been asked if there are any functional problems with a database having
>only relationships defined by queries. Will it be stable? Will there be
>issues and if so of what nature? Thanks!

If there are no relationships defined between the Tables, then relational
integrity will *not* be enforced. Access won't prevent users from entering
"orphan" records (for instance, an Order for a nonexistant Product, or a
Contact for a nonexistant Company).

Why would you want to turn off one of the most valuable features of the
program?

John W. Vinson [MVP]

no you should always use relationships and referential integrity



On May 23, 12:48 pm, Cheese <Che...@discussions.microsoft.com> wrote:
> I have been asked if there are any functional problems with a database having
> only relationships defined by queries. Will it be stable? Will there be
> issues and if so of what nature? Thanks!

Yes, I agree. This was not a database I created or are responsible for, just
something someone created eons ago. I find that users of access really like
the reporting feature and create a "database" of information in order to use
this feature without thought of using the full functionality of the database.
Thanks for your quick response, I am vindicated!

"John W. Vinson" wrote:

> On Wed, 23 May 2007 12:48:03 -0700, Cheese <(E-Mail Removed)>
> wrote:
>
> >I have been asked if there are any functional problems with a database having
> >only relationships defined by queries. Will it be stable? Will there be
> >issues and if so of what nature? Thanks!
>
> If there are no relationships defined between the Tables, then relational
> integrity will *not* be enforced. Access won't prevent users from entering
> "orphan" records (for instance, an Order for a nonexistant Product, or a
> Contact for a nonexistant Company).
>
> Why would you want to turn off one of the most valuable features of the
> program?
>
> John W. Vinson [MVP]
>