Microsoft jet database error not enough space on temporary disk

Privacy policy. Office ProPlus is being renamed to Microsoft Apps for enterprise. For more information about this change, read this blog post.

When you perform an operation on a table, you may receive the following error message if the operation creates a large number of page locks: There isn't enough disk space or memory.

If you run an action query on a large table, you may receive the following error message: There isn't enough disk space or memory to undo the data changes this action query is about to make. The page locks required for the transaction exceed the MaxLocksPerFile value, which defaults to locks. This section, method, or task contains steps that tell you how to modify the registry.

However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully.

Union contains more than columns fields. If a union contains more than columns, the following error occurs: Database error 0x Too many fields defined. This can cause the number of columns to exceed the column limit. Field names are limited to characters. Although Jet can read fields with names that are longer, many operations that you perform on those fields cause an "Unknown" error.

This limitation also causes fields to disappear without indication when you create an extract. Though tempdb is in auto grow if the mapped drive is full it wont create space.

Check the below command and try to find tempdb size. February 5, at am I want to add one more thing here. February 5, at pm I decided to debug the SP to see the exact point of error. Rank From TempTable T has , records to update. This is where it says 'No space on temporary disk. The minute I say update top 10 percent, it throws the same error. Now, why is this happening?? Follow Post Reply. Sorry Don, there's no obvious things you can investigate that you have not already done. It is hard to predict what Access does internally as temp space is used in the normal operation of the DB engine - and only the vendor will be able to trace where within the database the errors are actually occurring.

I think this is clearly an issue for the vendor to resolve and not to fob you off with inadequate responses about available disk space. Post Reply. Weird Error: There is not enough space on the disk. Error: There is not enough space on the disk. NET Framework. Win XP Error: There is not enough space on the disk. M last post: by.