Table specifications field/data type problem

[Rick4077]

Error . . .

"Microsoft Access can't change the data type. There isn't enough disk space or memory."

All I'm doing here is changing a known currency field to "currency" in lieu of text and decimal to 0. Also, a date field (text) from 255 to 10 Length.

Table is 54 fields. Automatic field length for most all of the fields is 255. Seems large to me.

I've tried compacting the table. No change!

I have Access 2003
2Gig RAM
200 GB hard drive 85 percent free!

Any ideas?

Thanks . . . Rick

 

[Rick4077]

Sheesh!!!

214,081 records, 52 fields.

Paradox 8 imports above described table in a few seconds with no problems!

Then it allows me to easily reformat the fields without a glitch.

What's the problem with Access 2003???

Rick