Connect to a networked access database from another
Posted on 2009-04-15
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.