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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
