VERY Green to QM

[purelife]

Possibly exist other ways to send data to Access, but it is not simple.

What about this:

Macro Macro1305

Code:

Copy      Help

,act w2
,err
,,mes "Failed to activate Access. Please activate it manually and then click OK." "" "!"
,,0.5

If fails to activate Access, shows message box. The you activate Access, click OK, and the macro continues.

GREAT! That seems to work...but here is the funny thing

So say the first 3 iterations work properly...then what would have typically happened was that error.
Now with your error code, the box comes up, and I click okay..and it continues like nothing happened

So I am wondering could it just be my system running out of resources at some point, and with that error box coming up gives it enough time to catch up with itself? I am copying 13 columns every time, and generally atleast 100 rows...sometimes 3~400.

Thanks again!