question about error code

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)
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query - key violation - no duplicates, records exist in par 4
append query errors 4
Numeric Field Overflow Error 5
append with union query? 6
Figuring out what field is causing key violation on append 6
Error 3183 4
Check if record exists 1
append query question in Access97 1

Top