Out of Disk Space when Changing Datatype

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a person who gets the following error when trying to change a datatype in Access from text to number(double):

Microsoft Access can't change the data type
There isn't enough disk space or memory
 
I assume you have checked the obvious, how much available disk-space is on
their machine?

How big(how many rows) is the table they are changing?

Have you made sure that there are no 'dodgy' values in the existing field
(non numeric etc.) Watch out for figures that look OK on a quick inspection:
10,5 - comma!
125. 66 - extra space!

Good luck,

ChrisM

Monique S said:
I have a person who gets the following error when trying to change a
Click to expand...
datatype in Access from text to number(double):
 
datatype in Access from text to number(double):
Click to expand...

Often the best way to do this is to create a new, empty, table with
the desired datatypes and then run an Append query to migrate the
data. Changing the datatype requires that Access keep both the old and
the new tables in memory - which for a big table can make even a
high-end machine choke.
 
Back
Top