Database with only query relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cheese - 23 May 2007 20:48 GMT

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!

Reply to this Message

John W. Vinson - 23 May 2007 21:59 GMT

>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]

Reply to this Message

Cheese - 24 May 2007 13:54 GMT

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!

> >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
[quoted text clipped - 9 lines]
>
> John W. Vinson [MVP]

Reply to this Message

dbahooker@hotmail.com - 23 May 2007 23:09 GMT

no you should always use relationships and referential integrity

> 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!

Reply to this Message