Search results
-
P
Access file became very large during updating
I am writing a vba procedure to updating some records in another Access database. rsAccess.Open "SELECT * FROM AI_Table",conAccess, adOpenForwardOnly, adLockPessimistic rsAccess!OCRExist = "Exist" rsAccess.Update it has about 3 millions of records in that AI_Table. In the procedure, I...