• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Connect to a networked access database from another

I have an access database located on one server and a shortcut to the interface on my desktop. I created forms and switchboards and they work ok. However, there is another seperate database (IRG) on a shared network server that I need to pull data. I was told I need to create a proceedure but I am not sure that is the correct way to go about it. Can I connect to a networked server DB and pull data when needed? Can I pull a data dump from it and import it at a certain time? Can I link the two? If anyone can show me an example of how I can do it, I would be most greatfull.
0
dudeatwork
Asked:
dudeatwork
1 Solution
 
peter57rCommented:
You can link the required tables from the second databse into the first database using File>GetExternalData>LinkTables.
They then behave as if they are part of the first database (except you can't change the design).  Which means of course, that if the data is changed in either database it is changed in both databases.
0
 
dudeatworkAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now