How do I permanently update the file name path in the Data Link properties?

lynnwalder · #1 05-04-2012, 08:43 AM

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...

macropod · #2 05-07-2012, 03:59 AM

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.

rdrios · #3 05-20-2013, 11:38 AM

Thanks a lot, very helpfull.

Quote:

Originally Posted by macropod

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Relative path for video link? Is it possible?	Baudisson	PowerPoint	1	01-10-2012 02:19 AM
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