Solved

Trying to change a field type

Posted on 2014-12-15
3
153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 38

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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

631 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