Thread: [Solved] Option for running SQL repeating before I can open report
View Single Post
 
Old 04-04-2012, 02:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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 Tom,

It sounds like your document's SQL metacode might have corrupted. Try opening the document and answering no to the prompts, then save & close the document. Re-open the document and there should be no prompts, as the SQL statement will have been deleted. You can then re-connect to the data source and re-save the document. From now on, you should only get one prompt.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote