Disk Out of Space Error

[shabar]

Hi All



I am getting following error when try to import csv file into MS access database. When check the size it's only 600 MB. I found this as a common issue in access.


Your computer is out of disk space

You won't be able to undo this paste append. Do you want to continue anyway


Is this anything to do with MaxLocksPerFile?
Appreciate your response

Cheers

Shabar

[tanvi]

The problem is probably the number of records you are importing. The import is running in a transaction and cannot get all the temporary records into the transaction file so it gives you the choice of stopping or continuing without the ability to undo. Temporary file size is limited by your system settings.

If you continue the import, the import is no longer running in a transaction and cannot be cancelled. There is really nothing wrong, just that you cannot UNDO the import.

[shabar]

Thax A lot tanvi