Application Specific Problems

PivotTable or Stored Query Targets Old DSN

Microsoft provides an Excel add-in to modify query connection strings and selection statements without using MSQuery. Download this utility here and follow these instructions:

1. Click HERE to download the add-in

2. Save the add-in to the "Library" folder within your MS Office application tree. The default location is —

   C:\Program Files\Microsoft Office\Office\Library

3. Open the spreadsheet you wish to modify.

4. On the Tools menu, select "Add-ins".

5. In the list, find "Query Table/Pivot Table Editor" and check the box next to it.

   (If it was already checked, but you find yourself unable to find the menu item in the next step, you may need to "re-install" the add-in by clicking the Browse button, then navigating to the "Library" folder where you put the file "ModifyQryPvtTbl.xla", and selecting it. Then hit "OK" in the Add-ins dialog.)

6. Select a cell ON the pivot table in your MasterMine report.

7. Now, on the Tools menu, click "Edit Query Table/Pivot Table".

8. In the dialog, change find the old path and modify it as desired. Then select Apply to make the change.

It is easy to make a mistake with this utility by entering invalid data. If the change does not work, DO NOT SAVE the Excel workbook and close it. You may then try again if necessary.

MS KB Article on changing query properties (including data source) in Access -- http://support.microsoft.com/kb/304356/

   Field List Properties

   To view the field list properties, in Design view of any query,                   

   right-click in any cell in the query design grid, and then click 

   Properties on the shortcut menu.


          

Property Name Description

Alias You can use the Alias property to specify a custom
name for a source table or query when you use the
same table or query more than once in the same query.

Source You can use the Source property to specify the source
connection string and source database for a query's
source table or query.