Connecting Tech Pros Worldwide Forums | Help | Site Map

Linking Tables

Newbie
 
Join Date: Dec 2007
Posts: 1
#1: Dec 28 '07
Hey,

I am not a programmer, just an advanced user at my work. We have an Access database that uses the network to store the data and on our C drive we have the program that runs it. We utilize 3 databases that are exactly the same, but are for different business units. I want to share some of the data between some of the tables, but not all of the tables. I tried making a new database that would hold the shared data and then linked each database to that table. But, the front end application says it cannot find the data now. I hope this makes some sense to someone. Is it possible to make this work? Thanks for your help.

nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#2: Dec 30 '07

re: Linking Tables


Hmm, strange.
The procedure would be:
1) Create new database with an imported "tblGeneralData"
2) Delete tblGeneralData from the frontend
3) Link tblGeneralData from the frontend.

(always first make a backup of the .mdb before deleting something !)

Where did this go wrong ?

Nic;o)
Reply