Out of Disk Space when Changing Datatype

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
 
C

ChrisM

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):
 
J

John Vinson

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.
 

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

Out of memory or disk space error when trying to change data type 2
Add autonumber to a large table? 0
More overhead using MEMO vs. TEXT datatype? 3
field data type errors 3
MS Access cant change the data type ; there is not enough disk space or memory. 4
decimal datatype conversion error 8
Data type error 4
Why can't I change a data type in an Access table? 3

Top