By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Linking Tables

P: 1

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.
Dec 28 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
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 ?

Dec 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.