Search results
-
P
Access file became very large during updating
The table is in an Access file. The Access file is now 400MB and the table has a few fields it it. When I just tried to update one field with a single character "Y" through VBA script, it Access file size will increase dramatically and crashed after it reached 2GB limit (when it updated about... -
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...