Not enough Disk Space or Memory Error Message 3

[ActMod]

When I try to save a change in the data type for a Table, I get an error message saying that there is not enough disk space or memory. I have plenty of disk space and memory. Does anyone know what Access is really trying to tell me?

Thank you for any help.

Jim

 

[LittleSmudge]

How big is the table ? How many records ?

What data type are you changing FROM - TO ?

Could you make a copy of the table and delete all but a small number of records
Compact the database
Then try the data type change on the smaller table
If you get the same error then it is definately NOT a Memory issue.


Have you tried
Add a new field to the table of the target data type
Create an Update Query to populate the new field based on the value in the old field
Delete the old field from the table



'ope-that-'elps







G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[nicsin]

ActMod,

I've had this problem several times in the past. I guess that you've got thousands even hundrends of thousands of records in the db, am I right? Access cannot perform an alter column on such a table and raises this error...don't know why though! Probably it does consume all your memory (physical + virtual). I'd say follow LittleSmudge's suggestion:

>Add a new field to the table of the target data type
Create an Update Query to populate the new field based on the value in the old field
Delete the old field from the table

You should be able to do that without problems.

regards,
nicsin

 

[ActMod]

LittleSmudge and nicsin,

Thanks much to both of you. Yes, nicsin, I am working with a large table with 169,000 records. I thought Access was designed for large databases - I guess I was wrong. Is there another database program that either of you might suggest that is better at dealing with large databases?

Thanks again.

Jim

 

[nicsin]

I think you are confused. Access can handle that amount of data (with limitations of course..., ie thread701-658228). It's just that the particular process you are trying to perform is (possibly) beyond its limits. As for other databases: MySql, PostgressSql, DB2, SQL Server, Oracle and it goes on... It depends on what you are doing basically.