Question Cant change the data type ; there is not enough disk space or memory

[byterbit]

Error:
" MS Access cant change the data type ; there is not enough disk space or memory."
(but of course there is)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Jet 4.0
Set up to 50000 Does nothing.

Copied all tables into new MDB; no difference.
Copied data into new table structure that uses much fewer total characters; does nothing.
Max 80 fields, one memo, 90000 records,60 MB
Removed recently added fields, does nothing.
I can delete fields but cant change field length.
This is happening both on 2007 and on 2003; structure is in 2003

 

[jdraw]

Sounds like there may be some corruption???
Have you tried Compact/Repair?

 

[byterbit]

This MAY have worked

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Jet 4.0
Set up to 50000

I set it, tested it to no avail, came back this morning after a reboot and this worked. (I spend half my time on Linux and forgot (!) about the need (?) to reboot.

I had tried compact/ repair first.

I should add my test was on my local WIN XP box; the production machine is a 2008 Server; who knows what will happen there.