Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow opening links between workbooks with links created in 2003 Russell Excel Discussion (Misc queries) 0 December 14th 09 02:59 PM
Create a query which links criterias to some cells in spreadsheet? Yuanhang Excel Discussion (Misc queries) 0 March 20th 08 01:04 AM
Maintaining links to cells for database query ranges Chris Excel Programming 2 May 24th 05 03:46 PM
saving wkbk minus MS Query links Bill_S Excel Discussion (Misc queries) 1 January 3rd 05 06:00 PM
MS query links removal in VBA Andrea[_5_] Excel Programming 0 September 18th 03 10:21 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"