Accessing User Defined External Queries

[sabascal]

Hi All,

I am working on a model linked to an access database.
The connection with the db is working fine.

some vb code is calling QueryDef("strQueryName") where "strQueryName" is probably a user defined query.

When going to Data > Get External Data I cannot click on edit query. Hence I don't know what this query look like.

How can I access to those user defined query?

Many thanks
Seb

 

[PHV]

This query is probably defined in the Access database.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

Hi,

If they are queries in Access, they are a "black box" and cannot be edited to find or change the criteria, for instance.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884