question about error code

  • Thread starter Thread starter jason.kohout
  • Start date Start date
J

jason.kohout

I am trying to run a simple append query, but the query takes a long
time and I get an error message:

Not enough room on temporary disk.

I have tried to increase the maxfilelocks in the regedit. I'm am
appending about 15 records.

Any thoughts?

Jason Kohout
(e-mail address removed)
 
Change it to a select query and see if it is really 'about 15 records' or a
lot more.

Easy way to do is to open the query in design view and on the icon bar icon
that shows two page click and select Select Query. Do not save but run it by
clicking on the red exclamation mark.
 
Back
Top