Search results

Thanks, spikepl. I'm not having luck with the DoEvents idea so I'll look into launching DB2 in its own shell next. Other than this issue, this procedure is working fine, which is a minor miracle in and of itself.

Thanks, Rx. That's exactly how I'm doing the SQL part, with a pass-through call to a SQL stored procedure. I can't create the Oracle stored procedure but will see if someone else who deals with it can. Part of the problem, which I forgot to mention, is that I'm in OR and the Oracle database is...

Hi everyone. I've done a lot of VBA in Excel programming, but not a lot in Access. Hopefully this problem has a simple fix but so far the solution has eluded me. General situation: My company stores data in different sources (Oracle, SQL Server, Excel, and Access). For lack of a better word...