Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Microsoft Access Queries not visible

srinath76
5 - Atom

I am connecting a MS Access db in input and I want to extract a query result into my workflow. While some queries are visible; most of them are not. Any solutions to this?

5 REPLIES 5
JoBen
11 - Bolide

Hi @srinath76, what version of MS Access and Alteryx are you using? Also, are the queries you are trying to access hidden in MS Access by chance?

srinath76
5 - Atom

Hi I'm using Alteryx Designer 2018.1 x64 and Microsoft Access 2016. They're not hidden. My issue is some queries are visible while others aren't. But all of them are visible to me when I open Access.

KlemensK
6 - Meteoroid

Hey, could it be that the hidden ones are only action queries? Or are also select queries hidden?

LJDL
6 - Meteoroid

Srinath, did you find a way to resolve this? I have a similar problem in that any new queries I create in Access are not visible to Alteryx. When I try to refresh the cached list of tables and queries it times out after 30 seconds. and shows it was last cached in June 2019. When I try on a different machine but connecting to the same database it says the cache has not been refreshed since 2014!

 

thanks

 

John

cmac2k
5 - Atom

It appears to me that Access queries that use the "Nz()" function will NOT appear in the list of queries available in Alteryx.  This was the specific situation for me.  Nz() is an Access-specific function, and that may be the problem.  I have not tested the visibility situation with queries that use other functions besides Nz().  So, for your queries that are not appearing in Alteryx's list, check to see if it is using any function at all.  That may be the culprit.

 

Labels