Saving Queries to include in ODBC

Database
Enthusiast

Saving Queries to include in ODBC

I have Access as the front-end, just migrated the tables to Teradata data labs. I was wondering instead of housing my queries that feed the forms in Access, is there a way for me to store them somewhere in my Teradata data labs DB and when I ODBC, I can see them? I tried pass-through queries so I would not get this ODBC call failed on my 2 data entry forms, however the forms are extremely complex and are looking through 567k records and even the pass-through ODBC call fails. So, I thought maybe if I stored the queries in Teradata data labs on my ODBC I could see them and maybe that would make things run faster?