Recent content by carefree

This is a multiple SQL report script that I am breaking up into constituent parts and run from Access. As a whole, from start to finish, the SQL is about 11k lines. Individual SQL statements range from 5k to 60k characters. It's quite extensive..

I have the connection string saved in the predefined pass through query.

Thanks for your input. I'll try 1, 2, and 4 but replacing the predefined query with the actual SQL tucked into the VBA script is not possible due to the length of the SQL that I am running. I really have no other option but to use the predefined queries.

Hello Minty, Here is what I tried to run: Dim db As Database Set db = CurrentDb DoCmd.SetWarnings False db.Execute "1E_INSERT_PLANNED_ORDERS_TempTbl", dbSQLPassThrough + dbFailOnError DoEvents db.Execute "2E_INSERT_PLANNED_ORDERS_2_TempTbl", dbSQLPassThrough + dbFailOnError DoEvents...

Here you go :) Option Compare Database Option Explicit Private Sub RunDPORScript_Click() On Error GoTo RunDPORScript_Click_Err DoCmd.SetWarnings False '---Clear Pre-existing Tables--- DoCmd.OpenQuery "1A_TRUNCATE_PLANNED_ORDERS_TempTbl", acViewNormal, acEdit DoCmd.OpenQuery...

Excellent feedback everyone. Thanks you! Give me time to attempt some of the insightful suggestions and I will post back if something works and what did.

Hello, I have a series of pass-through queries that flush (TRUNCATE) and fill (INSERT INTO) Global Temporary Tables in SAP HANA. When I run them individually/manually, they execute as intended and populate the tables accordingly. However, when I automate their execution with VBA, the TRUNCATE...

Hello, I'm a relatively inexperienced Access user (<5yrs?) but enjoy designing small scale solutions with the application and want to learn more, particular in regard to leveraging Access' backend VBA and SQL capabilities...