Solved

Trying to change a field type

Posted on 2014-12-15
3
141 Views
Last Modified: 2014-12-15
I'm trying to change a field type from text to currency in a table with 149,934 records but am getting an error ..  "There isn't enough disk space or memory".

Is there a work-around for this problem?
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 26

Expert Comment

by:Nick67
ID: 40501401
Add a new field to the table that is currency
write an append query to append the text coerced as currency to the field.
Delete the old field
Rename the new field to the old fields name
0
 
LVL 36

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 40501424
If the column is in the same row, it is an Update query.  Append queries add new rows.

If you still get an error with the new column and update query, then create a new empty table and use an append query to copy the data from the old table to the new table, converting the field in the process.  Once the new table is populated, rename/delete the original and rename the new back to the old table name.  WARNING - if you have autocorrect left on, make absolutely certain to turn it off before performing this operation or you'll be sorry.
0
 
LVL 26

Accepted Solution

by:
Nick67 earned 250 total points
ID: 40501470
Agreed
write an Update query to insert the text coerced as currency to the field.
Not
write an append query to append the text coerced as currency to the field.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question