LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 471
Default Access Reference

I have a workbook that in my testing is pulling data from and writing data to
an access .mdb file that is on a path, say, h:\mypath. But when this goes
into production, I will be moving that .mdb file to somewhere else on the
network. My question, is there a way to change the references to the
external data that is displayed in various parts of this workbook, or am I
better off deleteing (not sure how to do this either) all the references and
reestablishing them to the relocation .mdb location?
 
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
using a cell reference is Vloopup to access external workbooks Carl[_3_] Excel Programming 8 September 10th 07 08:32 AM
Reference a VBA Query from Access Andy Excel Programming 4 April 26th 07 08:32 PM
Reference Class Module in Access from Excel [email protected] Excel Programming 2 September 28th 05 09:55 AM
Reference Access created form in excel Ryan Patch Excel Programming 0 January 31st 04 08:01 PM
access the solver reference library CAB[_2_] Excel Programming 2 December 15th 03 07:30 PM


All times are GMT +1. The time now is 09:54 AM.

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

About Us

"It's about Microsoft Excel"