Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2012, 08:43 AM
lynnwalder lynnwalder is offline How do I permanently update the file name path in the Data Link properties? Windows XP How do I permanently update the file name path in the Data Link properties? Office 2010 64bit
Novice
How do I permanently update the file name path in the Data Link properties?
 
Join Date: May 2012
Posts: 1
lynnwalder is on a distinguished road
Default How do I permanently update the file name path in the Data Link properties?

Hopefully this will be the easiest troubleshooting thread posted on here today...

Working in Excel 2010 - Excel Database connection issue for a mail merge doc... the path to the file has changed, so every time I open up the word merge doc and it tries to connect to the excel doc via a SQL statement, I get a connection error and it opens up the Data Link box where I can manually update the path. BUT, it never saves this new path (so I have to do this EVERY time I open the word doc) - I HATE IT! How can I change the path for good so that this doesn't happen?

Thanks in advance for any help you can provide...
Reply With Quote
  #2  
Old 05-07-2012, 03:59 AM
macropod's Avatar
macropod macropod is offline How do I permanently update the file name path in the Data Link properties? Windows 7 64bit How do I permanently update the file name path in the Data Link properties? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi lynn,

When you open the document and get the SQL prompt, answer 'No'. Then re-connect the mailmerge to the data source in its new location. Form then on, the new connection will be the default.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-20-2013, 11:38 AM
rdrios rdrios is offline How do I permanently update the file name path in the Data Link properties? Windows 7 64bit How do I permanently update the file name path in the Data Link properties? Office 2010 64bit
Novice
 
Join Date: May 2013
Posts: 1
rdrios is on a distinguished road
Default Thanks

Thanks a lot, very helpfull.

Quote:
Originally Posted by macropod View Post
Hi lynn,

When you open the document and get the SQL prompt, answer 'No'. Then re-connect the mailmerge to the data source in its new location. Form then on, the new connection will be the default.
Reply With Quote
Reply

Tags
data link properties, mail merge, sql command

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link an object to a URL link to update automatically expert4knowledge Excel 1 06-11-2012 09:30 AM
How to re-link default email acct folders to default Outlook Data File folders? RDA1959 Outlook 0 03-26-2012 10:55 AM
How do I permanently update the file name path in the Data Link properties? Relative path for video link? Is it possible? Baudisson PowerPoint 1 01-10-2012 02:19 AM
How do I permanently update the file name path in the Data Link properties? Update Outlook but user path changed Ossie1972 Outlook 1 12-08-2010 08:19 PM
MM to Access 97 lost its link - broken by Windows Update? LesD Mail Merge 0 11-23-2010 07:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft