Hello,
I have written some VBA code in a adp in access using a SQL2K database. The code runs mostly SQL statements using the '.execute' command. There are several loops in the code which also use some recordsets in the data.
The code runs fine on my machine, taking about 15 mins to run. However when i pass it to my colleague (who has the same amount of memory but a slower processer) then it stops running half way through claiming to be out of memory; other programs still can be used at this point but Access can not, closing and reopening access does not free the memory. Both machines are running Access 2003.
What can i do to free the memory in Access after each loop of the program, or is there a setting that must be different between machines, or any other suggestions would be helpful
Thank you greatly
Barney
I have written some VBA code in a adp in access using a SQL2K database. The code runs mostly SQL statements using the '.execute' command. There are several loops in the code which also use some recordsets in the data.
The code runs fine on my machine, taking about 15 mins to run. However when i pass it to my colleague (who has the same amount of memory but a slower processer) then it stops running half way through claiming to be out of memory; other programs still can be used at this point but Access can not, closing and reopening access does not free the memory. Both machines are running Access 2003.
What can i do to free the memory in Access after each loop of the program, or is there a setting that must be different between machines, or any other suggestions would be helpful
Thank you greatly
Barney