Changing a Field Size

C

Chris

I am trying to change the Field Size of a field and when I attempt to save, I
get an error that says "There isn't enough disk or memory." Any suggestions
to help me out? If it helps, when compacted, the database is about 125 Mb.

Thanks
 
C

Chris

Access 2003. The database is stored on the company directory so no problems
with disk space. The memory I'm unsure of but I don't have a problem running
anything else.
 
J

John W. Vinson

I am trying to change the Field Size of a field and when I attempt to save, I
get an error that says "There isn't enough disk or memory." Any suggestions
to help me out? If it helps, when compacted, the database is about 125 Mb.

Thanks
Click to expand...

I'd suggest creating a new, empty table (copy and paste the existing one,
design mode only); change the field size in this new table; and run an Append
query to migrate the data. Drop any relationships to the old table,
reestablish them to the new table, and delete the old table - and compact and
repair again.

Back up the database first of course!!

John W. Vinson [MVP]
 
J

John W. Vinson

Access 2003. The database is stored on the company directory so no problems
with disk space. The memory I'm unsure of but I don't have a problem running
anything else.
Click to expand...

I think the problem is that when you attempt to change the design of a field
in an existing table, Access tries to load the entire table into memory TWICE
- the old table and the new one - before writing it out. Hence my suggestion
to use an append query instead; that will do it one record at a time rather
than the whole table.

John W. Vinson [MVP]
 
Top