vpellerito
Technical User
By gathering info from a user-form, I create a SQL string to be passed as a query definition in ADO.
Creating the SQL string works fine but when it comes to appending the query as a database view, the code takes too long.
Is there a way to run/create a select query without using ADO or DAO?
The DoCmd.RunSQL and CurrentDB.Execute commands will only work for action queries so I know I can not use those.
Thanks.
Vince
Creating the SQL string works fine but when it comes to appending the query as a database view, the code takes too long.
Is there a way to run/create a select query without using ADO or DAO?
The DoCmd.RunSQL and CurrentDB.Execute commands will only work for action queries so I know I can not use those.
Thanks.
Vince