[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Connect to a networked access database from another

Posted on 2009-04-15
2
Medium Priority
?
227 Views
Last Modified: 2013-11-28
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
Comment
Question by:dudeatwork
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 24147927
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
 

Author Closing Comment

by:dudeatwork
ID: 31570434
Thanks
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question