ms access faster query method
Posted on 2012-03-17
I have a query that I am running when a button is clicked. I am using the DoCmd.Openquery method to run the query.
Is there a method/code that is faster in access to run the query. I know ther are other ways to sepcify and run a query - wanted to know what my option are.
Here is the query:
INSERT INTO AC_DB2ADMIN_VIEWAECAPHEADER
Thanks for your help.