If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
When I try to change the data type I get an error that there isn'.
Changing the data type from double to text will not let me. It gives me the
error that there isn't enough disk space or memory and then doesnt' save the changes. |
#2
|
|||
|
|||
This can happen if:
- the database is large (hundreds of megabytes), or - the disk is nearly full (may need 3 or 4 times the mdb size spare), or - the temp environment variable is invalid (some versions of Windows). Try compacting the database: Tools | Database Utilities | Compact Create a new (blank) database. Then import the table from the database File | Get External | Import In the Import dialog, click Options, and choose Structure only. Open the table in design view, and change the field to Text. Then attach the table from the original database: File | Get External | Link Then use an Append query (Append on Query menu in query design view) to populate the new table from the attached table. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "KIKI" wrote in message ... Changing the data type from double to text will not let me. It gives me the error that there isn't enough disk space or memory and then doesnt' save the changes. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
change data type | JG | Using Forms | 2 | September 21st, 2004 03:57 AM |
can't change data type in table definition | Glenn Harwood | General Discussion | 4 | September 2nd, 2004 01:17 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
macro to change chart on excel data field | [email protected] | Charts and Charting | 3 | June 11th, 2004 05:16 PM |
Importing from Excel to Access | yolanda | Worksheet Functions | 2 | May 13th, 2004 10:16 AM |