Database with only query relationships

[Guest]

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!

 

[John W. Vinson]

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]

 

[dbahooker]

no you should always use relationships and referential integrity

 

[Guest]

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!