Not enough space on temporary disk.

[jshanoo]

Hi all,
-2147024882 [Microsoft][ODBC Microsoft Access Driver]
Not enough space on temporary disk.

I get this error whenever i try to delete the records from a table which have records running to 400000.

Can anyone help in this.

Regards
JOhn Philip

*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[Sashanan]

400000 records in an Access table? That's seriously pushing limits; might find you need a stronger DBMS for a database of that size.

Have no firsthand experience with Access databases that large but if my teacher back in college was to be believed, if you go beyond 100000 records or so in an Access table (depending on how many columns it has) you may run into seemingly random errors like the one you describe.


"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)

 

[CCLINT]

Try to increase the locks limitation directly in the registry (change back when done) : thread709-435674

 

[jshanoo]

Hi,
I increased it to 500000, but giving the same message.
even i have an earlier forum, But this can be done only to 100000, this i have tested and working fine.

Regards
John PHilip

*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[CCLINT]

You may need more locks than that (500,000) for 400,000 records. Depends on the statement used.

Therefore, you should limit the amount of records being delected to maybe 20,000 at a time and use a Lock of 50000.
Make sure you are using the correct Registry key for the JET Driver version AND the JET MDB version you are using.

Just why are you deleting so many records at once in a JET Mdb?
Are you trying to completely empty the table? May be better to just drop and re-create the table.

Oh, I also just noticed you are using the ODBC driver.
Use the JET 4 Provider instead.

 

[jshanoo]

Hi All,
I changed program a little, instead deletin from Access table , i change to delete from 'dbf' file and thenimport to access.
So it will not give me error.
Thank you everyone for your sincere advice.
Now i have new query, i have posted as new post.


Regards
John Philip

*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[vbajock]

You are probably getting an accurate error message. If you are using a SQL delete query, it is going to require a lot of temp disk space to do a mass delete. If this is the case, change the query to an ADO loop that deletes the records line by line and that will solve your problem.