excel-access link on different paths

[walleboo]

hello,

I have an excel file with multiple queries all linked to the same access database so they're all using one connection. The link between the 2 files is stable and works just fine, both the excel and the access files are on the same PC.

Now if I want to use the files and their links on a different PC the paths of the location where the 2 files are going to be stored are inevitably different so the connection will not work and neither will the queries.

The queries are a lot, probably over 100, is there a way to migrate the links to a new path all at once?

Thank you very much for any help

 

[apr pillai]

If you have a Broadband Router and have multiple connection slots then it is possible. The PC folder, where the Excel file is located, can be enabled for sharing with the other PC. Map the shared folder of the first pc like a network address: \\firstpcname\foldername on the second pc with a network Drive letter say T:. Using this address you can link the excel file on the second PC based Access Database.

It is better if you use the full network address (\\firstpcname\foldername\Excelfilename.xls) for linking the file rather than using the drive letter T. If you change the network mapping drive T: to something else later, the Link will not affect.

 

[walleboo]

thank you, that is a good advice. something I will definitely bear in mind if I do this kind of work again.
unfortunately I wasn't forward thinking. however the files should be used locally on the machine possibly on the go. This, I guess, means that the paths will have to be changed