Linked tables

Hi,
Thank you for your reponse.
---------------------------

Normally, tables are stored in the back-end, on a network
drive.
Each user should have a local copy of the front end.

Your front end can be linked to files from any number of
locations,
including both your I and your H drives.

HTH
-----------------------
I have other questions about the links, please.

Can I link tables located in front-end to any tables which
located at different locations.

Ex: Front-end have 2 tables (front-end and back-end at H
drive)

EQUIPMENT and DATA

Is it ok If I link the table EQUIPMENT to table named
EQUIPMENT at H drive?

Then I will link the table DATA to table named DATA at J
drive.

If I liked tables at front-end to different locations, the
back-end (in the H drive) is useless. Can i delete the
back-end?


--------------------

What I understand is each table at front-end can only link
to one table. Is that correct? It means it can not be
linked to two tables at the same time?

---------------------

Thank you very much
Loi

Splitting a database means that all of the tables reside in a file (typically
a file server) and the forms, reports, queries, macros etc reside in a file
on the individual computers on the network. A table isn't linked to a table.
A table is linked to your application.

"Loi" wrote:

Hi,
Thank you for your reponse.
---------------------------

Normally, tables are stored in the back-end, on a network
drive.
Each user should have a local copy of the front end.

Your front end can be linked to files from any number of
locations,
including both your I and your H drives.

HTH
-----------------------
I have other questions about the links, please.

Can I link tables located in front-end to any tables which
located at different locations.

Ex: Front-end have 2 tables (front-end and back-end at H
drive)

EQUIPMENT and DATA

Is it ok If I link the table EQUIPMENT to table named
EQUIPMENT at H drive?

Then I will link the table DATA to table named DATA at J
drive.

If I liked tables at front-end to different locations, the
back-end (in the H drive) is useless. Can i delete the
back-end?


--------------------

What I understand is each table at front-end can only link
to one table. Is that correct? It means it can not be
linked to two tables at the same time?

---------------------

Thank you very much
Loi