Solved

Trying to change a field type

Posted on 2014-12-15
3
140 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 35

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

809 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