Out of Disk Space Error

[John T Ingato]

Every week I import an Excel spreadsheet into my database, into a particular
table "SalesData 2006". This table at present has 758329 record, with 5
fields per record.

I tried to import the new worksheet today but I am getting an error message
that states,
"Your computer is out of disk space"
"You wont be able to undo the paste append. Do you want to continue anyway?"

I have 47GB left on my only harddrive. Surely enough. Any suggestions?

 

[Douglas J. Steele]

How big is the MDB file? Assuming Access 2000 or newer, it cannot exceed 2
Gb. (With Access 97 and previous, it could not exceed 1 Gb.)

Have you compacted the database recently (under Tools | Database Utilities)?

 

[John T Ingato]

Doug - The database is 101 MB and I have run compact. i am running Access
2003.
I went through with the append regardless of the message and it appears to
have imported all the records, but I would still like to figure this out.