Not enough space on tempory disk 3183

  • Thread starter Thread starter Stanley
  • Start date Start date
S

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
 
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
Click to expand...

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!
 
Back
Top