I have 200 Sharepoint tables, and want to download them all in MS Access. I do that programatically in VBE by downloading one table at a time by using the DoCmd.TransferSharePointList Method in a loop.
I noticed that after the 50th table, the routine becomes extremely slow.
I am worried I might be using the DoCmd.TransferSharePointList Method incorrectly. Do I need to close out something before I open the next table? Am I causing an overflow (such as a for without next, or Open without Close, or PUSH without POP)?
What command do I need to give to close out before opening the next table?