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