Error upon executing script

[Manymoe]

When I execute a script to scrape data from our mainframe, I receive
an error that system resources have been exceeded. The line taht
causes the error is as follows:

set rst1 = db.openrecordset("SELECT Year, Month, ERNO, EMP_NAME " _
& "FROM tblcollectionsnapshot_local " _
& "WHERE tblcollectionsnapshot_local.Year=" & varYear &
" AND tblcollectionsnapshot_local.Month=" & varMonth & " AND INS_FLAG
IS NULL AND FINS_FLAG IS NOT NULL AND ERNO NOT IN (" & strERNOHolder &
");",2)


We have not been able to figure out why out script will not run on one
machine but not another and the machines are similar in specs and
configuration.

Any asuggestions?