error changing data type

M

mmi

I have a 500-MB access 2002 database with several numeric
fields of type Double. I'm trying to convert the double
fields to decimal fields. I get the following error when
saving the table after applying the field change:
Microsoft Access can't change the data type. There isn't
enough disk space or memory.

I have 9 GB free on my hard drive, and I have 512 MB of
RAM. What do I need to do to convert these fields?
Thanks.
 
S

Sandra Robertson

Copy the table without carrying the data across, creating
an empty table. Make the changes in the empty table then
append the data from the old table to the new table.
That should work ok.

Sandy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Internal Data Integrity (Type 4) Details Needed 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
MS Access cant change the data type ; there is not enough disk space or memory. 4
error message changing data type 4
Report Will Not Open 2
converting word file to Adobe Acrobat pdf files 1
field data type errors 3
Data type conversion error 0

Top