- For further checking the error is not on the data type but in ADODB, it returning an error "Object was open"
- Modify the application for fixing this concern by closing the recordset and connection
- Test the application for checking if the error is now fixed
- still encountering the error upon testing.
- Modify the application script, changed the department filter split from by 30 into by 10 for department 1-60 and by 20 for department 61 to 100 and all for 101 above, this is to lessen the data extracted on each file and this also fixed the error when generating the files.
- Test the application if no more error will encounter, set the department filter into 1-30
- as per checking, no more error return
- execute the application to generate files with all department filter
- discuss with Arvin and email him for checking of the modified exe.