I have data on a shared drive that needs to be transferred to a local drive. there are about ten databases that need this. I then have a central database that links all these databases together. I would like to be able to transfer data from the shared drive to the local drive from the central database. I cannot find anything on this in Help or online. Does anyone know how to do this?
-
-
Originally posted by LynneH
Try linked table. Create a database on your local drive and link the required database objects from their previous location.
Or you can use sql to extract the data from the linked tables into your own tables that you would create on your local drive. -
I cannot link, our shared drive is extremely slow which is why this has to be done on the local drive.Comment
-
I think I have a similar situation to what you are describing, but I'm not quite sure how you have your databases setup.
I have the back ends of my databases sorted on the server (which bogs down quite a bit) and the front ends stored locally. In order to reduce the load on the server I have several of the tables that are not changed by the front ends stored as local tables within the front end programs. Every time the local program opens it checks the 'last updated' field for the local table against the 'last updated' field from the server's master table. If there have been changes, it links to the master and runs and update. If there haven't, it skips the update.
If that sounds like what you were trying to do I can give you more of a breakdown on how I set mine up.
Hope that helps! ^_^Comment
Comment