Larry Kahm said:
The existing application has BEData1.mdb on server and FEClient1.mde on
each workstation.
The new application has links to 4 tables from BEData1.mdb.
Questions:
1. Do these links go in the new back-end of this database - where the
relationship diagram exists?
We might be confusing some terms here. There is the term of what we call a
linked table from the front end to a back end table. Then there's also what
is called a relationship between tables that you can design and build in the
relationship diagramming system.
So as for the part about the relationship diagramming, and setting up of
relationships, this is always occurs in the back end, and you do this by
opening up the back end file direclity (so this process always occurs and is
done in the back end file).
2. Do the links only in the new front-end?
If you're speaking about the relationship between tables, then it goes in
the back end as per above. However, you front end will have what's called
linked tables to the back end. Hence that issue of semantics and the use of
"links" here.
So when you relate tables, or draw lines between the tables to define
Relationships we really don't call that idea linked tables, but we call that
related tables.
3. Do they go in both locations of the new application?
As a general rule if you open up the relationship diagramming tools in the
front and part of the application and drop and a few tables you will see the
relationships appear that were created in the back end database. However,
this setup and setting up the diagrams in the front is not required at all,
and would only amount to eye candy for your purposes. So any the
relationship setting is to be done in the back end (you'll actually find
that some relationships things cannot even be set in the front end when
working with back end tables in that front end...it is the back end that is
the boss here). if you think about it, this has to work this way because
what would happen if you had two different font end with two different
relationship settings, which one would win out? So the relationships are
always set in the actual data file itself, and not some other file that
might have a linked table to it...
If you want to read up on splitting you can read my articl here:
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
In the above I also bring up some issues such as how do you add a new field
to a table? (where do you do this).