ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MS Query links (https://www.excelbanter.com/excel-programming/335622-ms-query-links.html)

Markp

MS Query links
 

i am compiling an excel costing sheet that links to several external M
Access databases for its lookup data, how do i reestablish links to th
original databases when i view my files on a different pc to the one th
queries were created on. i repoint the data to the original database
but they wont refresh

--
Mark
-----------------------------------------------------------------------
Markp's Profile: http://www.excelforum.com/member.php...fo&userid=2106
View this thread: http://www.excelforum.com/showthread.php?threadid=39048


K Dales[_2_]

MS Query links
 
Two questions: what error message (or other indication of a problem) do you
get? And when you say you "repoint the data to the original databases" what
steps are you following to do that?
--
- K Dales


"Markp" wrote:


i am compiling an excel costing sheet that links to several external MS
Access databases for its lookup data, how do i reestablish links to the
original databases when i view my files on a different pc to the one the
queries were created on. i repoint the data to the original databases
but they wont refresh.


--
Markp
------------------------------------------------------------------------
Markp's Profile: http://www.excelforum.com/member.php...o&userid=21064
View this thread: http://www.excelforum.com/showthread...hreadid=390483




All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com