Linking Same Data within Several Data Bases

[Guest]

I have discovered that I have four data bases each producing different
reports: operators, landownders, tent sizes, tent supplies. But each data
base is based on a table of locations and tent numbers. If a description for
these changes I have to go into each data base and change the same
information within each. Is there a way to link all of them with a table in
one database so they will update automatically?

 

[John W. Vinson]

I have discovered that I have four data bases each producing different
reports: operators, landownders, tent sizes, tent supplies. But each data
base is based on a table of locations and tent numbers. If a description for
these changes I have to go into each data base and change the same
information within each. Is there a way to link all of them with a table in
one database so they will update automatically?

Certainly.

Don't confuse data STORAGE with data PRESENTATION. A Report isn't data, and
you should not have a different table for each report! A Report is a way of
*presenting* data. If these four reports all refer to the same information,
then you should have one shared database containing the Tables (hopefully more
than one table; if you have Locations and Tents that's two tables right
there). Each user should have a "frontend" database, with just Forms, Queries
and Reports, linked to the single shared "backend" database.

See

http://www.granite.ab.ca/access/splitapp/index.htm

for a description of how this can be set up.

John W. Vinson [MVP]

 

[Guest]

How do I accomplish setting up a back bone datebase with the tables and a
front end with the forms and reports? I tried earlier, but I am not sure how
to connect the info.

 

[John W. Vinson]

How do I accomplish setting up a back bone datebase with the tables and a
front end with the forms and reports? I tried earlier, but I am not sure how
to connect the info.

You can split an existing database using Tools... Database Utilities...
Database Splitter Wizard; or do it manually, setting up a backend database
with the tables, and creating a new database, using File.... Get External
Data... Link to connect to the tables.

See a thorough discussion at Tony Toews' site:

http://www.granite.ab.ca/access/splitapp.htm

John W. Vinson [MVP]