I've been having a constant issue with multiple Access programs that I've created. Recently we've moved our iSeries offsite about 1,000 miles away. Before the move, I didn't have any issue running update or append queries in Access to our iSeries system. After the move, I've had severe lag issues where what used to take at most a minute, now takes 30+ minutes. I had a break through today on my issue. I also use Toad Data Point and I attempted to do a simple Update query to one column using an ODBC connection through Toad and it took under 8 seconds to change 190,000 rows. When I ran the exact same query through Access it takes over 20 minutes to complete (with the program going into a non responsive state as well). I noticed that the SQL coding in Access is slightly different than that of Toad.
Does anyone know why there would be such a performance issue or has anyone encountered this before?