Database with only query relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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]
 
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!
 
Back
Top