Linked tables

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

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?
 
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
 
You can certainly link your front end to one file on your I drive for one
table, and to a different file on your J drive for another table, if you
like.

If these are the only tables you need, you could get rid of whatever's on
the H drive.
(I'd recommend making a backup before deleting it, though; you never know
when you'll wish you had it back!)

Each linked table (in the database window, these show up on the Tables tab,
and have a big arrow next to them) connects to one and only one table in the
back end. One link cannot connect to two back end files at the same time.
If you need the data from two files, create a separate link to each table,
then use a query in the front end to join them.

HTH
- Turtle
 
Back
Top