E
Eddy
I am doing an upload from a txt file into 8 various lookup tables in
Access2003. Is there a benefit to opening 8 recordsets initially and
leaving them open until the data is uploaded? Or would it be beneficial to
do a Select/Case and open the appropriate recordsets only when I need to
then close them until next needed.
Looking to determine if speed or corruptability or any other factors I
haven't thought of would dictate which means to use.
Thanks
Access2003. Is there a benefit to opening 8 recordsets initially and
leaving them open until the data is uploaded? Or would it be beneficial to
do a Select/Case and open the appropriate recordsets only when I need to
then close them until next needed.
Looking to determine if speed or corruptability or any other factors I
haven't thought of would dictate which means to use.
Thanks