Not enough space on tempory disk 3183

[Stanley]

I am updating about 2000 records through a loop in Access 2002. I have been
recently getting the above error (the program has been running OK for many
years).
I've seen references to a temp file as a solution for this, but I don't seem
to be able to determine its exact location and fix its size.
Thanks,
Stanley

 

[John W. Vinson]

I am updating about 2000 records through a loop in Access 2002. I have been
recently getting the above error (the program has been running OK for many
years).
I've seen references to a temp file as a solution for this, but I don't seem
to be able to determine its exact location and fix its size.
Thanks,
Stanley

Please post your code. Updating via a single Update query may be much more
efficient than a VBA loop, but without knowing what you're trying to do, I
have no idea if it's feasible in your case!