VBA 3035

[papai]

Hello
I am doing a project on MS Access Database using VB Scriptis about making a
extractor tool (MS Access Database application) that would extract 28 table
from Oracle database and then make an extracted MS Access db with those 2
tables along with data. We are using MS Access form and VBA code as front end
The 28 tables would have around 1.5 crore rows. The problem we are facing no
i
while loading that Oracle data in the access database, after loading aroun
15-20 lac data (size 175 mb) on a go, we have got an vba error. The vba erro
description is : error no. 3035, error description. System Resource Exceeded

Please help anyone.

 

[Sjouke Burry]

Hello,
I am doing a project on MS Access Database using VB Scriptis about
making an extractor tool (MS Access Database application) that would
extract 28 tables from Oracle database and then make an extracted MS
Access db with those 28 tables along with data. We are using MS
Access form and VBA code as front end. The 28 tables would have
around 1.5 crore rows. The problem we are facing now
is
while loading that Oracle data in the access database, after loading
around 15-20 lac data (size 175 mb) on a go, we have got an vba
error. The vba error description is : error no. 3035, error
description. System Resource Exceeded.

Please help anyone.

Heed the warning, and do the job in smaller bites(not bytes).
You are running out of space with the bigger bite.