Find Access Database Used by MSQuery in Excel 2003

[Mike Knight]

I have a MSQuery on a sheet in Excel 2003 that queries data from a
table in an MS Access Database.

I can "see" all the tables in the Access Database, but I can not
determine where the database is located or what it's name is on our
server.

How can I get the path and name?

Thanks,
Mike

 

[Dick Kusleika]

Mike

You can look at the Connection property, but only through VBA.

Sheet1.QueryTables(1).Connection

will return the connection string which includes the path and name of the
dbase.

Here's some more info on External Data

http://www.dicks-clicks.com/excel/ExternalData.htm