Relationships - specify in front-end or back-end

M

MikeB

When I started my database, I had everything in one access file (.mdb)
then I read here that it is a good idea to split the tables from the
queries and the forms into a back-end (tables only) and a front-end
(forms, queries etc).

Now I notice that I have a Tools -> Relationship diagram in both the
front-end and the back end. Which one does Access use? Can I safely
delete one? I don't really think it is correct that this information
should be in two places at the same time.

Thanks.
 
C

Cheese_whiz

Hi Mike,

Here's a pasted answer from John Vinson in another forum recently:
________________________________________________
The relationships can only exist and be enforced in the backend; that's where
the tables are. Relationships established in a DIFFERENT database (a frontend)
would have no way of being enforced, since someone could open the backend
directly, or from a different frontend.

So: relationships are *only* in the backend. Anything in the frontend is just
for documentation or information, not for controlling the data.
_________________________________________________


HTH. If it does, give me credit. If it doesn't, blame John :)
CW
 
T

Tony Toews [MVP]

Cheese_whiz said:
HTH. If it does, give me credit. If it doesn't, blame John :)

Both you and John are correct.

Always ignore the relationships diagram in the front end.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
J

John W. Vinson

Hi Mike,

Here's a pasted answer from John Vinson in another forum recently:
________________________________________________
The relationships can only exist and be enforced in the backend; that's where
the tables are. Relationships established in a DIFFERENT database (a frontend)
would have no way of being enforced, since someone could open the backend
directly, or from a different frontend.

So: relationships are *only* in the backend. Anything in the frontend is just
for documentation or information, not for controlling the data.
_________________________________________________


HTH. If it does, give me credit. If it doesn't, blame John :)

<g> Thanks Cheese_whiz.

Just an additional note - relationships in the frontend are generally
"inherited" from the "real" relationships in the backend. They're not totally
useless, in that when you create a new Query involving two tables, the join in
the query will be defined based on the stored relationship.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top