Tuesday, 15 September 2015

ms access - System Resources Exceed Error with BeginTrans and Execute methods -


Trying to run an updated query (with 2 tables included in SQL) via Begintrans , I'm getting stuck

CurrentDB.Execute method A " more than the system resource " appears for a few seconds. Set DAO.WORKSPACE StrWORKSPACE = DBEngine in the form of a sub-updade_clients () slow dbLOCAL_DB as the database dim strSQL string retard strWORKSPACE. Works (0) strSQL = "" & amp; _ "Update TBL_IND_CLIENTE_2008_01 Join INNER TBL_IND_CLIENTE_2011_01 ON" & amp; _ "TBL_IND_CLIENTE_2008_01.NUMERO = TBL_IND_CLIENTE_2011_01. EURO SET" & amp; _ "TBL_IND_CLIENTE_2008.01.CONJUNTO_ELETRICO = [TBL_IND_CLIENTE_2011_01]! [CONJUNTO];" --text "itemprop =" text ">

This means that it is going out of memory 1.5 million records = headache. < / Html>

No comments:

Post a Comment