Not enough space on disk

[jason]

Whenever I try to make changes to my database and save them, I get the error
"Not enough space on disk."
This DB is saved on a SBS2003 server which has plenty (over 200G) of space
left available. When I copy the database to my local PC and make changes, it
saves without a problem.
Does anyone have any experience with this?
I haven't knowingly made changes in Group Policy to cause this, I don't even
know what it would be under.

Help!

 

[John Vinson]

Whenever I try to make changes to my database and save them, I get the error
"Not enough space on disk."

If you're trying to change the definitions of fields in a large table,
Access will sometimes give this misleading error. It happens because
(apparently) Access must copy the ENTIRE table into memory, make the
change, and then copy it back - it's a virtual memory error,
basically.

One getaround is to create a NEW table with the revised field
definitions, empty; run an Append query to migrate the data from the
old table into the new one; check the result; delete the old table
(dropping all relationships first if there are any); rename the new
one and reestablish relationships.


John W. Vinson[MVP]