Query Information

  • Thread starter Thread starter viktor
  • Start date Start date
Viktor, click in the external data, then click Edit Query on the External
Data toolbar. If the Query Wizard appears, cancel it, then click Yes when
prompted to edit the data in Microsoft Query.

In Microsoft Query, the SQL command on the View menu displays the underlying
SQL, and the Add tables command on the Table menu brings up a dialog box
that shows the location (drive:\path) of the database.

Hope this helps.
 
the problem is :
i change my SQL server and all existing query keeping the old name of the
server in the code. i know that thereis a command that in VB editor that can
show me the path of query tables but i forget what was that.
 
Back
Top