No more diskspace error (there is plenty)

  • Thread starter Thread starter Frank M.
  • Start date Start date
F

Frank M.

I am trying to import data to an Access base. I want to
load about 600.000 records to a table. After about
160.000 I get an error "There is no more diskspace... The
last Insert command can not be undone. Do you want to
continue?"
If I reply "yes", thinking that now it will continue the
operation, even if I wont have the option to undo.
Shortly after it says "Property not found", and the
import fails with no records being imported.
I have tried to split up the file in 4 parts, thinking
that I could import them one after the other. Still, I
get the same error once I reach about 160-170.000
records. The sequence of the imports does not matter.
What can be wrong here?

Btw, the error messages has been translated, as I have a
Danish version of Office XP.

Regards,

Frank
 
Frank M. said:
I am trying to import data to an Access base. I want to
load about 600.000 records to a table. After about
160.000 I get an error "There is no more diskspace... The
last Insert command can not be undone. Do you want to
continue?"
If I reply "yes", thinking that now it will continue the
operation, even if I wont have the option to undo.
Shortly after it says "Property not found", and the
import fails with no records being imported.
I have tried to split up the file in 4 parts, thinking
that I could import them one after the other. Still, I
get the same error once I reach about 160-170.000
records. The sequence of the imports does not matter.
What can be wrong here?

Btw, the error messages has been translated, as I have a
Danish version of Office XP.

Regards,

Frank
Click to expand...

How big is the database file before and after this process? You may be
running up against the 2GB limit on the size of an Access .mdb file.
 
Along with DIrk's idea, you may want to try a compact and repair of the
database.
 
ACC2000: Error Message: There Isn't Enough Disk Space or Memory
http://support.microsoft.com/default.aspx?scid=kb;en-us;209940


___________________________________________

I am trying to import data to an Access base. I want to
load about 600.000 records to a table. After about
160.000 I get an error "There is no more diskspace... The
last Insert command can not be undone. Do you want to
continue?"
If I reply "yes", thinking that now it will continue the
operation, even if I wont have the option to undo.
Shortly after it says "Property not found", and the
import fails with no records being imported.
I have tried to split up the file in 4 parts, thinking
that I could import them one after the other. Still, I
get the same error once I reach about 160-170.000
records. The sequence of the imports does not matter.
What can be wrong here?

Btw, the error messages has been translated, as I have a
Danish version of Office XP.

Regards,

Frank
 
Thanks for your replys.

It was not the 2 Gb limit. The database is only about 30
Mb. Compressing and repair did not help either.

In the end I created a new database with the same schema
and reloaded everything that worked. Must have been some
corruption that could not be repaired.

Frank
 
Back
Top