VBA 3035

December 27th, 2012 - 04:29 pm ET by papai | Report spam
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.
email Follow the discussionReplies 1 replyReplies Make a reply

Replies

#1 Sjouke Burry
December 27th, 2012 - 04:47 pm ET | Report spam
papai wrote in
news::

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.

Similar topics